Re: case dumbiness in return from functions

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: case dumbiness in return from functions
Дата
Msg-id 20080118124308.GB5326@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: case dumbiness in return from functions  (Nico Sabbi <nsabbi@officinedigitali.it>)
Ответы Re: case dumbiness in return from functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Nico Sabbi wrote:

> yet I find disturbing that Postgres doesn't make the effort
> to respect the case specified by the user.

It does -- if you quote the names.

> If I created a field
> called "REF" why should Postgres call it "ref" in the output of queries
> if the standard doesn't specify any obligation to convert the name ?

Actually I think the standard mandates case-folding (though to upper
case rather than lower, i.e. the other way around)

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

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

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: case dumbiness in return from functions
Следующее
От: "Gregory Williamson"
Дата:
Сообщение: Re: Online Oracle to Postgresql data migration