Re: [GENERAL] column names and dollar sign

2017-05-17 Thread Gavin Flower
On 18/05/17 11:59, John R Pierce wrote: On 5/17/2017 4:51 PM, Gavin Flower wrote: Variables ending in '$' date back to at least the early days of BASIC - long before the spectre of Microsoft loomed large, let alone 'Visual Basic'! I note even INT fields have $ names there... IBM used to

Re: [GENERAL] column names and dollar sign

2017-05-17 Thread John R Pierce
On 5/17/2017 4:51 PM, Gavin Flower wrote: Variables ending in '$' date back to at least the early days of BASIC - long before the spectre of Microsoft loomed large, let alone 'Visual Basic'! I note even INT fields have $ names there... IBM used to like to use $ in names for system stuff,

Re: [GENERAL] column names and dollar sign

2017-05-17 Thread Gavin Flower
On 18/05/17 11:32, Neil Anderson wrote: "Armand Pirvu (home)" writes: Ran into the following statement CREATE TABLE test( Date$ date, Month_Number$ int, Month$ varchar(10), Year$ int ); A strange naming convention. It has a whiff of Visual Basic

Re: [GENERAL] column names and dollar sign

2017-05-17 Thread Neil Anderson
>> "Armand Pirvu (home)" writes: >>> Ran into the following statement >> >>> CREATE TABLE test( >>> Date$ date, >>> Month_Number$ int, >>> Month$ varchar(10), >>> Year$ int >>> ); A strange naming convention. It has a whiff of Visual Basic Type

Re: [GENERAL] column names and dollar sign

2017-05-17 Thread Armand Pirvu (home)
Thanks Tom Armand On May 17, 2017, at 4:14 PM, Tom Lane wrote: > "Armand Pirvu (home)" writes: >> Ran into the following statement > >> CREATE TABLE test( >> Date$ date, >> Month_Number$ int, >> Month$ varchar(10), >> Year$

Re: [GENERAL] column names and dollar sign

2017-05-17 Thread Tom Lane
"Armand Pirvu (home)" 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

Re: [GENERAL] column names and dollar sign

2017-05-17 Thread Armand Pirvu (home)
Thank you Steve — Armand On May 17, 2017, at 4:10 PM, Steve Atkins wrote: > >> On May 17, 2017, at 2:02 PM, Armand Pirvu (home) >> wrote: >> >> Hi >> >> Ran into the following statement >> >> CREATE TABLE test( >> Date$ date, >>

Re: [GENERAL] column names and dollar sign

2017-05-17 Thread Steve Atkins
> On May 17, 2017, at 2:02 PM, Armand Pirvu (home) > wrote: > > Hi > > 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

[GENERAL] column names and dollar sign

2017-05-17 Thread Armand Pirvu (home)
Hi 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 ? Can anyone shed some light please ? Thanks Armand -- Sent via