Re: version issue? - Mailing list pgsql-general

From Dan Wilson
Subject Re: version issue?
Date
Msg-id 002301c0a014$f4f6f7f0$533987cf@corp.peoplesoft.com
Whole thread Raw
In response to version issue?  ("Dan Wilson" <phpPgAdmin@acucore.com>)
List pgsql-general
Excellent! That worked! Thank you once again Tom!  I was under the
impression that you couldn't use an alias in the ORDER BY.  Obviously, I was
mistaken.

Thanks,
-Dan

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>

: "Dan Wilson" <phpPgAdmin@acucore.com> writes:
: > : Possibly some future release will actually do the right thing with
ORDER
: > : BY of an expression on the output columns, but right now it has to be
an
: > : output column, period.
:
: > OK... I tried adding UPPER(last_name) to the result column lists of both
: > sides of the union and it still gives me the same error.
:
: You have to use the SQL-standard syntax for ORDER BY, ie column name or
: number, no shortcuts:
:
: SELECT ..., UPPER(last_name) AS upper_last_name
: UNION
: SELECT ..., UPPER(last_name) AS upper_last_name
: ORDER BY upper_last_name;
:
: or if you prefer, ORDER BY n where n is the ordinal number of the
: column.
:
: regards, tom lane


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: version issue?
Next
From: Doug McNaught
Date:
Subject: Re: newbie question