Re: MULTISET and additional functions for ARRAY

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: MULTISET and additional functions for ARRAY
Дата
Msg-id AANLkTinRhhwPUuJNHWA=srq1NumQVVKTPqz8TATe0Xbu@mail.gmail.com
обсуждение исходный текст
Ответ на Re: MULTISET and additional functions for ARRAY  ("David E. Wheeler" <david@kineticode.com>)
Ответы Re: MULTISET and additional functions for ARRAY  (Darren Duncan <darren@darrenduncan.net>)
Список 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 по дате отправления:

Предыдущее
От: "David E. Wheeler"
Дата:
Сообщение: Re: MULTISET and additional functions for ARRAY
Следующее
От: Darren Duncan
Дата:
Сообщение: Re: MULTISET and additional functions for ARRAY