Re: Strange behavior of "=" as assignment operator

2013/5/28 Stephen Frost <sfrost@snowman.net>:
> * Moshe Jacobson (moshe@neadwerx.com) 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.
>
> My general feeling is that we should either document it *as* legacy
> or add it to the "list-of-things-to-break-in-10.0". :)

should be cleaned and removed

same undocumented behave has GET DIAGNOSTICS STATEMENT, ":=" is
allowed there :-(

note from source code

assign_operator>: '='<->/* not documented because it might be removed someday */
<------><------><------><------>| COLON_EQUALS
<------><------><------><------>;

Regards

Pavel



>
>         Thanks,
>
>                 Stephen