Adrian Klaver wrote: > On 06/20/2015 12:41 PM, Charles Clavadetscher wrote: >> I just made a short test with the code provided. As Bill mentioned the >> moment when the trigger is fired is essential. >> I made a test with both before (worked) and after (did not work because >> the row was already inserted and the returned new row is ignored). >> >> The assignment (= or :=) does not seem to play a role, but the correct >> version is as mentioned := > > Yea, I can't seem to remember this part of the docs: > > " Equal (=) can be used instead of PL/SQL-compliant :=." This was discussed on -hackers a while ago: http://www.postgresql.org/message-id/flat/52EF20B2E3209443BC37736D00C3C1380876BDC7@xxxxxxxxxxxxxxxxxxxxxxxxx#52EF20B2E3209443BC37736D00C3C1380876BDC7@xxxxxxxxxxxxxxxxxxxxxxxxx It's a rather long and rambling thread, but what I got from it was that "=" for assignments is something that just works by accident, is discouraged and left alive only to avoid breaking code that uses it. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
