Search Postgresql Archives

Re: Strange behavior of "=" as assignment operator

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2013/5/28 Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx>:
> On 05/28/2013 01:06 PM, Stephen Frost wrote:
>>
>> * Moshe Jacobson (moshe@xxxxxxxxxxxx) wrote:
>>>
>>> It seems that the comparison operator "=" is functioning as the
>>> assignment
>>> operator ":=" in this plpgsql trigger script I wrote. I was under the
>>> impression that "=" is only for comparison and not assignment. If this is
>>> true, please explain the transcript below. If it's not true, where is
>>> this
>>> documented? I'm using PostgreSQL 9.1.4.
>>
>> Both are supported.  It's not really documented as using '=' is
>> considered 'legacy' but it's also extensively used and removing it would
>> break quite a bit of code for people.
>>
>>
>
> You mean legacy code as provided in the documentation examples?
> http://www.postgresql.org/docs/9.3/static/plpgsql-trigger.html (see examples
> 39-5 and 39-6).
>
> Fixing the example code is probably a low-hanging-fruit place to start. I
> don't have time right now or I'd submit a patch.

this is bug and should be fixed. I''ll send a patch.

Pavel

>
> Cheers,
> Steve
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux