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