Return Table with Stored Procedure in PostgreSql?

Asked Nov 20 '19 at 07:48

Active Nov 20 '19 at 07:54

Viewed 302 times

How can I return table in Stored Procedure ? I can do it in function but I have inout parameters.So I can not create in function. What can I do this case ?

Iguess,It should be like for function :

CREATE or REPLACE FUNCTION public."test" (INOUT "x" integer, INOUT "y" text)

RETURNS TABLE  (
"id" integer,
"filesize" character varying(36)
)
AS $$
 BEGIN
RETURN QUERY
SELECT * FROM    public."tbl_employees" ;

END;
$$ LANGUAGE plpgsql;

Thanks.

edited Nov 20 '19 at 07:54

Moon

4,014
3
30
66

asked Nov 20 '19 at 07:48

İlyas Derse

Use a procedure when you don't want to return data. Use a function when you do. – Laurenz Albe Nov 20 '19 at 07:54
1

Stored procedures aren't meant to return anything. Your function is the best way to do that in Postgres – Nov 20 '19 at 07:55
So I can not use a inout parameter – İlyas Derse Nov 20 '19 at 07:56

Return Table with Stored Procedure in PostgreSql?

0 Answers0