Re: named parameters in SQL functions - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: named parameters in SQL functions
Date
Msg-id 162867790911151059v11cc86a1i82b341b386a7bee7@mail.gmail.com
Whole thread Raw
In response to Re: named parameters in SQL functions  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
2009/11/15 Greg Stark <gsstark@mit.edu>:
> On Sun, Nov 15, 2009 at 6:42 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
>>> Personally, I like $var, but @var would be okay, and @@var is acceptable. But I'm JAPH, so my biases should be
obvious.
>>
>> @var or @@var should be a break for people from MySQL. @var are r/w in
>> MySQL and @@var are global in T-SQL. So people could be confused.
>
> Besides, do we think MySQL and T-SQL are the heights of good language design?
>

sure no. But same arguments against to :var should be used to @var.
pgscript use it. I don't know the best semantic. But I am not happy
from this proposals. I don't see any consistency.

Pavel


>
> --
> greg
>


pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: named parameters in SQL functions
Next
From: Andrew Chernow
Date:
Subject: Re: named parameters in SQL functions