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

From Alban Hertroys
Subject Re: Record with a field consisting of table rows
Date
Msg-id 333BBDD1-5A64-4127-98E6-46908C0A34D7@solfertje.student.utwente.nl
Whole thread Raw
In response to Re: Record with a field consisting of table rows  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Record with a field consisting of table rows  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
On 13 Jan 2011, at 19:25, Pavel Stehule wrote:

>> 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'?
>>
>
> no. PostgreSQL doesn't supports SET. Only arrays are supported.


I'm not sure what you mean here, Postgres certainly _does_ support set-returning functions. Maybe you were referring to
somethingin the particular context of the problem the OP is trying to solve? 

It would be kind of bad if people Google for this topic and would come back with the wrong conclusion.

Alban Hertroys

--
Screwing up is an excellent way to attach something to the ceiling.


!DSPAM:737,4d2f4de411871554341128!



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Inconsistent time interval formatting
Next
From: Alban Hertroys
Date:
Subject: Re: Record with a field consisting of table rows