Re: Why lower's not accept an AS declaration ?

On Mon, 18 Aug 2003, [iso-8859-15] Herv� Piedvache wrote:

> Mistake ? Why a mistake ... it's as you said an alias ... for result ... I
> know that ... but why order by my alias is running ... and NOT an order by
> with a LOWER() function call is not running ... that's mean LOWER() do not
> accept alias ... but ORDER accept ... so sorry for me it's not so logical !

SQL92 doesn't allow expressions in order by, but you can name output
columns of the select list.  We extend the specification in a way similar
to SQL99 to allow expressions on the input columns of the select list.  We
do not extend it to expressions upon the output columns of the select list
(although re-reading SQL99 makes me believe that it would allow such).