Why lower's not accept an AS declaration ?

Поиск
Список
Период
Сортировка
От Hervé Piedvache
Тема Why lower's not accept an AS declaration ?
Дата
Msg-id 200308181020.13759.herve@elma.fr
обсуждение исходный текст
Ответы Re: Why lower's not accept an AS declaration ?  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Why lower's not accept an AS declaration ?  (Darko Prenosil <darko.prenosil@finteh.hr>)
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Lamb
Дата:
Сообщение: Re: Need feedback on new feature (\for)
Следующее
От: Johann Uhrmann
Дата:
Сообщение: Performance with different index types