Re: Record with a field consisting of table rows

From: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
To: Jon Smark <jon(dot)smark(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Record with a field consisting of table rows
Date: 2011-01-16 16:51:45
Message-ID: 33CD092E-3888-486C-A692-F32833143771@solfertje.student.utwente.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 16 Jan 2011, at 17:40, Jon Smark wrote:

> Again, you're making it sound like I'm requesting something exotic,
> while any language with a modern type system allows this and much
> more without blinking. In Ocaml, for example, the return type 'page_t'
> of my function could be defined as follows:
>
> type user_t = { uid: int; name: string; age: int; }
> type page_t = int * user_t list

That's the refcursor option I gave you earlier.

Alban Hertroys

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

!DSPAM:737,4d33222411702065417953!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrus Moor 2011-01-16 17:00:58 Re: How to generate unique invoice numbers for each day
Previous Message Mag Gam 2011-01-16 16:44:48 database slowdown