Re: MULTISET and additional functions for ARRAY - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: MULTISET and additional functions for ARRAY
Date
Msg-id AANLkTinRhhwPUuJNHWA=srq1NumQVVKTPqz8TATe0Xbu@mail.gmail.com
Whole thread Raw
In response to Re: MULTISET and additional functions for ARRAY  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: MULTISET and additional functions for ARRAY
List pgsql-hackers
On Thu, Nov 11, 2010 at 3:42 PM, David E. Wheeler <david@kineticode.com> wrote:
> On Nov 11, 2010, at 12:08 PM, Alvaro Herrera wrote:
>
>>> That sounds like a composite type to me.
>>
>> No, it's "perpendicular" in the sense that while a composite type allows
>> you to have different columns, this multiset thing lets you have "rows"
>> (I initially thought about them as sets of scalars, but AFAIU they could
>> in turn be rows)
>
> How is that different from an array of RECORDs?

not a whole lot outside of syntax details...there is a decent summary
here: http://waelchatila.com/2005/05/18/1116485743467.html

I like this part: "Alternatively the SQL standard also permits the
same construct with the bracket trigraphs ??( and ??)"  :-D

merlin


pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: MULTISET and additional functions for ARRAY
Next
From: Darren Duncan
Date:
Subject: Re: MULTISET and additional functions for ARRAY