Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION load_page(IN _session integer)
- RETURNS TABLE(col1 text, col2 text) AS
- $BODY$
- BEGIN
- RETURN QUERY
- select
- (SELECT array_agg(sq.*)
- FROM (SELECT user_id, user_name
- FROM "user"
- ) sq
- )::text,
- (SELECT array_agg(sq.*)
- FROM (SELECT client_id, client_name ,client_desc
- FROM "clients"
- ) sq
- )::text;
- END;
- $BODY$
- LANGUAGE plpgsql STABLE
- COST 100
- ROWS 1000;
- ALTER FUNCTION load_page(integer) OWNER TO postgres;
- The Result is :
- "("{""(2,Test)"",""(5,Santhosh)"",""(3,Test1)""}","{""(1,Test1,Test1)"",""(2,test2,test2)"",""(3,test3,test3)""}")"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement