Re: functional call named notation clashes with SQL feature

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: functional call named notation clashes with SQL feature
Date: 2010-05-28 17:25:57
Message-ID: 4BFFFCA5.7060008@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 28/05/10 19:19, Josh Berkus wrote:
> ( parameter := value ) notation is not only consistent with what is used
> inside pl/pgsql, it's also more consistent than "AS" with SQL Server's
> named parameter notation, which is:
>
> EXEC dbo.GetItemPrice @ItemCode = 'GXKP', @PriceLevel = 5
>
> Since former SQL Server / Sybase apps are the most likely to use named
> parameter notation in PostgreSQL, having a syntax which could be ported
> using only "sed" would be nice.

Once you solve the problem of finding the '='s in the source, replacing
them is exactly the same effort regardless of what you replace them with.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andy Balholm 2010-05-28 17:50:07 Re: [BUGS] dividing money by money
Previous Message Heikki Linnakangas 2010-05-28 17:22:05 Re: How to pass around collation information