Re: referencing column names properly

Поиск
Список
Период
Сортировка
От Ross J. Reedstrom
Тема Re: referencing column names properly
Дата
Msg-id 20030209225615.GA11550@wallace.ece.rice.edu
обсуждение исходный текст
Ответ на Re: referencing column names properly  ("Sill-II, Stephen" <Stephen.Sill-II@ost.dot.gov>)
Список pgsql-sql
On Sun, Feb 09, 2003 at 09:18:05AM -0500, Sill-II, Stephen wrote:
>  Thanks much!  After much experimentation, I figured it out.  I remember
> reading in the postgres oreily book that if you don't quote the identifiers,
> that it converts them all to lowercase for processing.  Does the dash in the
> name also require the name to be quoted?

Yup, so the expression parser can differentiate between a-b (column"a"
- column "b") and a-b (column named "a-b").

Ross


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

Предыдущее
От: "A.M."
Дата:
Сообщение: order by date desc but NULLs last
Следующее
От: "Ross J. Reedstrom"
Дата:
Сообщение: Re: order by date desc but NULLs last