Обсуждение: Re: [GENERAL] Re: Bug#108286: case sensitivity in column names

Поиск
Список
Период
Сортировка

Re: [GENERAL] Re: Bug#108286: case sensitivity in column names

От
Tom Lane
Дата:
"Oliver Elphick" <olly@lfix.co.uk> writes:
> Ketil Malde wrote:
>>>> Notice how it uses mixed case column names here?

> And therefore should have double-quoted them.

Or not double-quoted them --- but it has to be consistent about it.
"FooBar" and FooBar are not the same name according to the SQL standard.
So if you quote column names in the CREATE TABLE command, you have to
quote 'em forevermore.  And if not, not.

            regards, tom lane