Re: Record with a field consisting of table rows

2011/1/14 Jon Smark <jon(dot)smark(at)yahoo(dot)com>:
> Hi,
>
> This thread has veered off-topic, but my original problem still remains.
> Basically, I want to declare a function that returns a tuple consisting
> of an integer and a set of table rows.  Something like the following:
>
> CREATE FUNCTION foobar () RETURNS (int4, SETOF users)
>

you have to use a array

CREATE FUNCTION foo(... OUT total int, OUT _users users[])

there are no other way

Regards

Pavel Stehule

> Now, if I understand correctly, the only way to have a function return
> a tuple is to create a named record and have the function return that
> record:
>
> CREATE TYPE page_t AS
>  (
>  total  int4
>  users  SETOF users
>  )
>
> Which is of course not grammatical.  So, how does one solve this problem
> in PL/pgSQL?
>
> Thanks in advance!
> Jon
>
>
>
>
>