fork download

copy

CREATE OR REPLACE FUNCTION INSERTINCIDENT
(
	p_incident_name TEXT,
	p_full_text TEXT,
	p_registered_by INTEGER
) 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,
    p_incident_name,
    p_full_text,
    now,
    p_registered_by,
    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
   	incidentid,
	incidentname,
	full_text
FROM INSERTINCIDENT('件名','本文本文本文', 1);

Main.java:1: error: class, interface, or enum expected
CREATE OR REPLACE FUNCTION INSERTINCIDENT
^
Main.java:19: error: class, interface, or enum expected
now TIMESTAMP WITH TIME ZONE;
^
Main.java:21: error: class, interface, or enum expected
BEGIN
^
Main.java:23: error: class, interface, or enum expected
SELECT CURRENT_TIMESTAMP INTO now;
^
Main.java:25: error: class, interface, or enum expected
INSERT INTO incidents
^
Main.java:44: error: class, interface, or enum expected
RETURN QUERY
^
Main.java:56: error: class, interface, or enum expected
END;
^
Main.java:57: error: class, interface, or enum expected
$$ LANGUAGE plpgsql;
^
Main.java:58: error: unclosed character literal
'?????????????'
^
Main.java:58: error: illegal line end in character literal
'?????????????'
              ^
Main.java:60: error: unclosed character literal
'???????????????????????????'
^
Main.java:60: error: illegal line end in character literal
'???????????????????????????'
                            ^
Main.java:65: error: unclosed character literal
FROM INSERTINCIDENT('??','??????', 1);
                    ^
Main.java:65: error: unclosed character literal
FROM INSERTINCIDENT('??','??????', 1);
                                ^
14 errors

Standard output is empty