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

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: WITH RECURSIVE ... CYCLE in vanilla SQL: issues with arrays of rows
Дата
Msg-id b42b73150810131240i5995ccer5e21166bdf8233d3@mail.gmail.com
обсуждение исходный текст
Ответ на 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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Mon, Oct 13, 2008 at 9:56 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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.


...meaning, that you would not be able to create a function taking
generic 'record' as a parameter?  In that case I agree...any chance of
getting an updated patch?

merlin


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

Предыдущее
От: Zdenek Kotala
Дата:
Сообщение: Re: Year 2038 Bug?
Следующее
От: "David E. Wheeler"
Дата:
Сообщение: Re: Year 2038 Bug?