| From: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | Jon Smark <jon(dot)smark(at)yahoo(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Record with a field consisting of table rows |
| Date: | 2011-01-13 19:09:13 |
| Message-ID: | 333BBDD1-5A64-4127-98E6-46908C0A34D7@solfertje.student.utwente.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 something in 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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2011-01-13 19:21:23 | Re: Record with a field consisting of table rows |
| Previous Message | Tom Lane | 2011-01-13 19:03:20 | Re: Inconsistent time interval formatting |