Re: column names and dollar sign

From: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
To: Neil Anderson <neil(at)postgrescompare(dot)com>, "Armand Pirvu (home)" <armand(dot)pirvu(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: column names and dollar sign
Date: 2017-05-17 23:51:39
Message-ID: 721580b7-2d33-633e-0339-067b68d18b35@archidevsys.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 18/05/17 11:32, Neil Anderson wrote:
>>> "Armand Pirvu (home)" <armand(dot)pirvu(at)gmail(dot)com> 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
> Characters about it,
> https://docs.microsoft.com/en-us/dotnet/articles/visual-basic/programming-guide/language-features/data-types/type-characters.
>
> Any chance there is a connection there?
>
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'!

Cheers,
Gavin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2017-05-17 23:59:00 Re: column names and dollar sign
Previous Message Neil Anderson 2017-05-17 23:32:29 Re: column names and dollar sign