Re: Can a function return more then one table?
| От | Pavel Stehule |
|---|---|
| Тема | Re: Can a function return more then one table? |
| Дата | |
| Msg-id | CAFj8pRDHgkmSrhw9oMe+H9MWr1ELF+8kok=a4t-QQNO9d_wmzA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Can a function return more then one table? (Mike Christensen <mike@kitchenpc.com>) |
| Ответы |
Re: Can a function return more then one table?
Re: Can a function return more then one table? |
| Список | pgsql-general |
Hello 2012/1/11 Mike Christensen <mike@kitchenpc.com>: > 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) Regards Pavel Stehule > Mike > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: