From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | Greg Stark <gsstark(at)mit(dot)edu>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: functional call named notation clashes with SQL feature |
Date: | 2010-05-31 16:03:40 |
Message-ID: | AANLkTike2WAWV-Gl_7RK8tCwgEdWxjwrfDAyQ_goOspc@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
2010/5/31 Bruce Momjian <bruce(at)momjian(dot)us>:
> Pavel Stehule wrote:
>> >> Part of the earlier discussion was about how => was a tempting
>> >> operator name and other users may well have chosen it precisely
>> >> because it's so evocative. But we don't actually have any evidence of
>> >> that. Does anyone have any experience seeing => operators in the wild?
>> >
>> > Tangentially, I think the SQL committee chose => because the value, then
>> > variable, ordering is so unintuitive, and I think they wanted that
>> > ordering because most function calls use values so they wanted the
>> > variable at the end.
>>
>> maybe, maybe not. Maybe just adopt Oracle's syntax - nothing more,
>> nothing less - like like some others.
>
> Yea, definitely they were copying Oracle. My point is that the odd
> ordering does make sense, and the use of an arrow-like operator also
> makes sense because of the odd ordering.
>
What I know - this feature is supported only by Oracle and MSSQL now.
MSSQL syntax isn't available, because expected @ before variables. So
there is available only Oracle's syntax. It is some like industrial
standard.
Pavel
> --
> Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + None of us is going to be here forever. +
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2010-05-31 16:14:12 | Re: functional call named notation clashes with SQL feature |
Previous Message | Bruce Momjian | 2010-05-31 15:57:08 | Re: functional call named notation clashes with SQL feature |