Re: WITH RECURSIVE ... CYCLE in vanilla SQL: issues with arrays of rows

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: WITH RECURSIVE ... CYCLE in vanilla SQL: issues with arrays of rows
Дата
Msg-id 12276.1223906215@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: WITH RECURSIVE ... CYCLE in vanilla SQL: issues with arrays of rows  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: WITH RECURSIVE ... CYCLE in vanilla SQL: issues with arrays of rows  ("Merlin Moncure" <mmoncure@gmail.com>)
Список pgsql-hackers
I wrote:
> "Merlin Moncure" <mmoncure@gmail.com> writes:
>> select foo from foo order by foo;
>> ERROR:  could not identify an ordering operator for type foo

> Yeah, these are because of the incomplete handling of named record
> types.  I'm not sure how far we want to go in that direction.

On looking closer, all these cases fail because I forgot to teach
IsBinaryCoercible() that any composite type should be considered
binary-coercible to RECORD.  Which is clearly sensible.

I'm inclined to apply the patch with binary-coercibility adjustments
and not try to turn RECORD or RECORD[] into full-fledged polymorphic
types.  It's not immediately clear what the use of that would be
anyway.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Zdenek Kotala
Дата:
Сообщение: Re: pg_upgrade: convert on read is dead end
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: out-of-date comment in auto-generated oidjoins.sql