Re: Coercing compound types to use generic ROW comparison operators

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Coercing compound types to use generic ROW comparison operators
Дата
Msg-id 12212.1192140674@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Coercing compound types to use generic ROW comparison operators  (Randall Lucas <rlucas@tercent.com>)
Ответы Re: Coercing compound types to use generic ROW comparison operators
Список pgsql-general
Randall Lucas <rlucas@tercent.com> writes:
> Still, this would fail in a nested situation because it wouldn't
> recurse (if col1 of the compound type were another compound type,
> ferinstance), as would your suggestion above.  It might be worthwhile
> to allow choosing to use the default ROW comparison operator at
> composite type creation (which would provide a more elegant solution to
> nested situations).

You are incorrectly supposing that there *is* such an animal as a
default row comparison operator --- actually, ROW() = ROW() is expanded
at parse time into field-by-field comparisons.  This is usually a good
thing since it gives the planner more flexibility.

            regards, tom lane

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

Предыдущее
От: Randall Lucas
Дата:
Сообщение: Re: Coercing compound types to use generic ROW comparison operators
Следующее
От: "Carlos H. Reimer"
Дата:
Сообщение: RES: RES: 8.2.4 selects make applications wait indefinitely