> 2012/1/11 Mike Christensen <mike@xxxxxxxxxxxxx>: >> I would like to write a function that returns one row from one table, >> and about 10 rows or so from another table.. >> >> Is there a clean way to do this, or am I better off making two separate queries? >> >> I'm thinking maybe I can use OUT parameters for the first table, and >> the return value for the second table? However, I have no idea what >> the syntax would be like. >> > > what is possible > > * return setof refcursors > * use arrays instead tables and returns arrays (for tables less 10000 rows) Thanks! Both of these options sound feasible, I will play around with some code and see what I can come up with. Mike -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
