Re: INSERT a number in a column based on other columns OLD INSERTs

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Charles Clavadetscher <clavadetscher(at)swisspug(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: INSERT a number in a column based on other columns OLD INSERTs
Date: 2015-06-20 19:48:58
Message-ID: 5585C3AA.5000802@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 06/20/2015 12:41 PM, Charles Clavadetscher wrote:
> Hello
>
> 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 :=."

>
> Bye
> Charles
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message litu16 2015-06-21 01:07:21 Re: INSERT a number in a column based on other columns OLD INSERTs
Previous Message Charles Clavadetscher 2015-06-20 19:41:23 Re: INSERT a number in a column based on other columns OLD INSERTs