fork download

copy

drop function INSERTINCIDENT();
 
CREATE OR REPLACE FUNCTION INSERTINCIDENT() RETURNS TABLE
(
	incidentid INTEGER,
	incidentname TEXT,
	fulltext TEXT,
	registeredat TIMESTAMP WITH TIME ZONE,
	registeredby INTEGER,
	lastupdatedat TIMESTAMP WITH TIME ZONE
)
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,
    full_text,
    registered_at,
    registered_by,
    last_updated_at
)
VALUES
(
    incidentid,
    '件名',
    '本文本文本文',
    now,
    1,
    now
);
 
RETURN QUERY
SELECT
    incident_id,
    incident_name,
    full_text,
    registered_at,
    registered_by,
    last_updated_at
FROM
	incidents
WHERE
	incident_id = incidentid;
END;
$$ LANGUAGE plpgsql;
 
SELECT
    *
FROM INSERTINCIDENT();

Main.java:1: error: class, interface, or enum expected
drop function INSERTINCIDENT();
^
Main.java:3: error: class, interface, or enum expected
CREATE OR REPLACE FUNCTION INSERTINCIDENT() RETURNS TABLE
^
Main.java:16: error: class, interface, or enum expected
now TIMESTAMP WITH TIME ZONE;
^
Main.java:18: error: class, interface, or enum expected
BEGIN
^
Main.java:20: error: class, interface, or enum expected
SELECT CURRENT_TIMESTAMP INTO now;
^
Main.java:22: error: class, interface, or enum expected
INSERT INTO incidents
^
Main.java:34: error: unclosed character literal
    '??',
    ^
Main.java:34: error: unclosed character literal
    '??',
       ^
Main.java:35: error: unclosed character literal
    '??????',
    ^
Main.java:35: error: unclosed character literal
    '??????',
           ^
Main.java:41: error: class, interface, or enum expected
RETURN QUERY
^
Main.java:53: error: class, interface, or enum expected
END;
^
Main.java:54: error: class, interface, or enum expected
$$ LANGUAGE plpgsql;
^
Main.java:56: error: class, interface, or enum expected
SELECT
^
14 errors

Standard output is empty