Advertisement
Guest User

Untitled

a guest
Aug 27th, 2016
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION load_page(IN _session integer)
  2. RETURNS TABLE(col1 text, col2 text) AS
  3. $BODY$
  4. BEGIN
  5. RETURN QUERY
  6. select
  7. (SELECT array_agg(sq.*)
  8. FROM (SELECT user_id, user_name
  9. FROM "user"
  10. ) sq
  11. )::text,
  12. (SELECT array_agg(sq.*)
  13. FROM (SELECT client_id, client_name ,client_desc
  14. FROM "clients"
  15. ) sq
  16. )::text;
  17. END;
  18. $BODY$
  19. LANGUAGE plpgsql STABLE
  20. COST 100
  21. ROWS 1000;
  22. ALTER FUNCTION load_page(integer) OWNER TO postgres;
  23.  
  24.  
  25. The Result is :
  26.  
  27. "("{""(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