fork download

copy

CREATE OR REPLACE FUNCTION insert() RETURNS VOID
AS
$$
DECLARE
incidentid INTEGER;
now TIMESTAMP WITH TIME ZONE;
 
BEGIN
SELECT COALESCE(MAX(incident_id + 1),1) INTO incidentid FROM incidents;
SELECT CURRENT_TIMESTAMP INTO now;
 
INSERT INTO incidents
(
    incident_id,
    incident_name,
    fulltext,
    registered_at,
    registered_by,
    last_updated_at
)
VALUES
(
    incidentid,
    '件名',
    '本文本文本文本文'
    now,
    1,
    now
);
END;
$$ LANGUAGE plpgsql;

Main.java:1: error: class, interface, or enum expected
CREATE OR REPLACE FUNCTION insert() RETURNS VOID
^
Main.java:6: error: class, interface, or enum expected
now TIMESTAMP WITH TIME ZONE;
^
Main.java:8: error: class, interface, or enum expected
BEGIN
^
Main.java:10: error: class, interface, or enum expected
SELECT CURRENT_TIMESTAMP INTO now;
^
Main.java:12: error: class, interface, or enum expected
INSERT INTO incidents
^
Main.java:24: error: unclosed character literal
    '??',
    ^
Main.java:24: error: unclosed character literal
    '??',
       ^
Main.java:25: error: unclosed character literal
    '????????'
    ^
Main.java:25: error: illegal line end in character literal
    '????????'
             ^
Main.java:30: error: class, interface, or enum expected
END;
^
Main.java:31: error: class, interface, or enum expected
$$ LANGUAGE plpgsql;
^
11 errors

Standard output is empty