Re: Unquoted column names fold to lower case
От | Dev Kumkar |
---|---|
Тема | Re: Unquoted column names fold to lower case |
Дата | |
Msg-id | CALSLE1NcZj2gQAr9PxUC_2o_OJVQYbvLqr_0zhGPSLrjyXocTQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Unquoted column names fold to lower case (Bruce Momjian <bruce@momjian.us>) |
Ответы |
Re: Unquoted column names fold to lower case
|
Список | pgsql-sql |
On Thu, Jul 4, 2013 at 1:36 AM, Bruce Momjian <bruce@momjian.us> wrote:
Sorry but I am not sure about your point here. Currently if the alias is quoted then same needs to be used in queries as identifies:
SELECT 1 AS "X"
ORDER BY "X";
And let's not forget that column aliases can be used as indentifiers in
queries:
test=> SELECT 1 AS x
test-> ORDER BY x;
x
---
1
(1 row)
test=> SELECT 1 AS "X"
ORDER BY x;
ERROR: column "x" does not exist
LINE 2: ORDER BY x;
Changing this would mean that the same identifier would have different
case-folding rules depending on where it appeared in the query.
Sorry but I am not sure about your point here. Currently if the alias is quoted then same needs to be used in queries as identifies:
SELECT 1 AS "X"
ORDER BY "X";
Regards...
В списке pgsql-sql по дате отправления: