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

On Mon, Aug 18, 2003 at 10:20:13AM +0200, Hervé Piedvache wrote:
> You can imagine my test is simple, in practise it's not the reallity of my
> original request ... but this example is just to show that lower() function
> does not accept an AS declaration ... is it normal ?

Yes, that's normal. It's even required by the SQL spec AFAIK. If it's a
problem of multiple evaluation, you can use subqueries in the FROM clause.

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato