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
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 ?
Thanks for your answers ...
Regards,
--
Hervé Piedvache
Elma Ingénierie Informatique
6 rue du Faubourg Saint-Honoré
F-75008 - Paris - France
Pho. 33-144949901
Fax. 33-144949902
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
