"Josh Berkus" <[EMAIL PROTECTED]> writes:
>> Just FYI, I have committed code for 7.1 that allows ORDER BY to work
>> correctly for a UNION'd query. A limitation is that you can only do
>> ordering on columns that are outputs of the UNION:
> As far as I know, that limitation is standard to all SQ
Tom,
> Just FYI, I have committed code for 7.1 that allows ORDER
> BY to work
> correctly for a UNION'd query. A limitation is that you
> can only do
> ordering on columns that are outputs of the UNION:
As far as I know, that limitation is standard to all SQL
that supports UNION; the relational
Quite awhile ago, Michael Richards <[EMAIL PROTECTED]> wrote:
> It looks like the order by is only being applied to the original select,
> not the unioned select. Some authority should check on it, but by thought
> it that a union does not necessarily maintain the order, so the entire
> select sho
