Re: Why lower's not accept an AS declaration ? - Mailing list pgsql-general

On Monday 18 August 2003 10:20, Hervé Piedvache wrote:
> Hi,
>
> May be my question is stupid ... but I'm a little suprised :
>
> SELECT id_letter as letter from my_table;
>
> letter
> -----
> B
> C
> a
> A
>
> SELECT id_letter as letter from my_table order by letter;
>
> letter
> -----
> A
> B
> C
> a
>
> SELECT id_letter as letter from my_table order by lower(letter);
>
> ERROR:  Attribute "letter" not found
>


Why did you change column name to "letter" in last query, and all the other
queries have "id_letter" as column name. What is table structure exactly ?
I assume that You don't have column with "letter" at all.

Regards !