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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ed Loehr <eloehr(at)austin(dot)rr(dot)com>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pggeneral <pgsql-general(at)postgresql(dot)org>
Subject: Re: order by + union (was: query syntax change?)
Date: 2001-07-06 20:00:26
Message-ID: 18331.994449626@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ed Loehr <eloehr(at)austin(dot)rr(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-07-06 20:18:15 Re: orphaned RI constraints
Previous Message Tom Lane 2001-07-06 19:47:42 Re: Number of days