Re: [GENERAL] column names and dollar sign

Поиск
Список
Период
Сортировка
От Armand Pirvu (home)
Тема Re: [GENERAL] column names and dollar sign
Дата
Msg-id 8968E675-1BE8-4439-A421-837389747509@gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] column names and dollar sign  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [GENERAL] column names and dollar sign  (Neil Anderson <neil@postgrescompare.com>)
Список pgsql-general
Thanks  Tom


Armand

On May 17, 2017, at 4:14 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> "Armand Pirvu (home)" <armand.pirvu@gmail.com> writes:
>> Ran into the following statement
>
>> CREATE TABLE test(
>>     Date$ date,
>>     Month_Number$ int,
>>     Month$ varchar(10),
>>     Year$ int
>> );
>
>> While it does execute, I wonder if the $ has any special meaning ?
>
> Postgres thinks it's a valid identifier character, as long as it's
> not the first character.  I don't believe it's standard SQL, but
> we hacked it in a long time ago for compatibility with Oracle or
> somebody like that.
>
>             regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] column names and dollar sign
Следующее
От: Neil Anderson
Дата:
Сообщение: Re: [GENERAL] column names and dollar sign