Postgres Pro
Downloads
Home   >   mailing lists

Can a function return more then one table? - Mailing list pgsql-general

From Mike Christensen
Subject Can a function return more then one table?
Date
Msg-id CABs1bs3d2vRmv9WtFfNnxu2j30Tc4F-P-f3Yooyif0imSLfMqg@mail.gmail.com
Whole thread Raw
Responses Re: Can a function return more then one table?  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view 
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.

Mike

pgsql-general by date:

Previous
From: Kevin Duffy
Date:
Subject: pgAdmin - Query - out of memory for query result
Next
From: Pavel Stehule
Date:
Subject: Re: Can a function return more then one table?