Re: Record with a field consisting of table rows - Mailing list pgsql-general

From Jon Smark
Subject Re: Record with a field consisting of table rows
Date
Msg-id 846280.61221.qm@web112803.mail.gq1.yahoo.com
Whole thread Raw
In response to Re: Record with a field consisting of table rows  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Record with a field consisting of table rows  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Hi,

> That is certainly not going to work: that select does not produce an
> array, it produces a column of user_t (of which SELECT INTO is only
> gonna take the first, anyway).
>
> Untested, but I think you'd have better results with
>
>     _page.users := array(select users from users limit 10);

The above does work, thanks.  There is however one drawback: the type
associated with _page.users is now an array.  Is there a way to make
it a 'SETOF user_t'?

Best regards,
Jon





pgsql-general by date:

Previous
From: Allen Chen
Date:
Subject: Inconsistent time interval formatting
Next
From: Pavel Stehule
Date:
Subject: Re: Record with a field consisting of table rows