Re: id and ID in CREATE TABLE

Поиск
Список
Период
Сортировка
От Josh Jore
Тема Re: id and ID in CREATE TABLE
Дата
Msg-id Pine.BSO.4.44.0207190407250.2596-100000@kitten.greentechnologist.org
обсуждение исходный текст
Ответ на Re: id and ID in CREATE TABLE  (stefan@extum.com)
Список pgsql-sql

Joshua b. Jore ; http://www.greentechnologist.org

On Sat, 20 Jul 2002 stefan@extum.com wrote:

> Why is like this ? Why not letting them upper case if they are not quoted
> ?
>
> stefan

Well.. this is because pgadmin created the attribute as "ID" originally so
for you - it's always been double-quoted to force the case. I never quote
my identifier literals just to avoid all the strange problems (like this)
that happen when you do it. It's just a bad idea.

Josh


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

Предыдущее
От: stefan@extum.com
Дата:
Сообщение: Re: id and ID in CREATE TABLE
Следующее
От: stefan@extum.com
Дата:
Сообщение: Re: [GENERAL] id and ID in CREATE TABLE