Re: order by + union (was: query syntax change?)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: order by + union (was: query syntax change?)
Дата
Msg-id 18331.994449626@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: order by + union (was: query syntax change?)  (Ed Loehr <eloehr@austin.rr.com>)
Список pgsql-general
Ed Loehr <eloehr@austin.rr.com> writes:
>> Btw., order by + union doesn't work prior to 7.1 anyway.

> Looks like order by + union was enabled at least in 7.0.3, fwiw...

Nonetheless, it had bugs crawling out of it everywhere ... try more
complex test cases, and pay attention to whether you actually get
the right answer (like the right sort order, distinct/not distinct,
etc).  Cross-datatype cases tended to coredump, too.

I believe this mess is all fixed as of 7.1.

            regards, tom lane

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

Предыдущее
От: "omid omoomi"
Дата:
Сообщение: Re: Number of days
Следующее
От: Tom Lane
Дата:
Сообщение: Re: orphaned RI constraints