CREATE OR REPLACE FUNCTION pgsql_record1
(OUT i int, OUT t
text)
RETURNS SETOF RECORD AS $$
values
(1,'integer'),(2,'text')
$$ LANGUAGE SQL;
save the script :
Note the function pgsql_record1 , added under the current db/schema
Script Generated:
-- Function: pgsql_record1()
-- DROP FUNCTION
pgsql_record1();
CREATE OR REPLACE FUNCTION pgsql_record1(OUT i
integer, OUT t text)
RETURNS SETOF record AS
$body$
values
(1,'integer'),(2,'text')
$body$
LANGUAGE sql VOLATILE
COST
100
ROWS 1000;
ALTER FUNCTION pgsql_record1()
OWNER TO
postgres;
Now call This function from another SQL-Query Window.
