Postgres Pro
Downloads
Home   >   mailing lists

Re: INSERT a number in a column based on other columns OLD INSERTs - Mailing list pgsql-general

From Adrian Klaver
Subject Re: INSERT a number in a column based on other columns OLD INSERTs
Date
Msg-id 5585C3AA.5000802@aklaver.com
Whole thread Raw
In response to Re: INSERT a number in a column based on other columns OLD INSERTs  (Charles Clavadetscher <clavadetscher@swisspug.org>)
Responses Re: INSERT a number in a column based on other columns OLD INSERTs  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-general
Tree view 
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.klaver@aklaver.com

pgsql-general by date:

Previous
From: Charles Clavadetscher
Date:
Subject: Re: INSERT a number in a column based on other columns OLD INSERTs
Next
From: litu16
Date:
Subject: Re: INSERT a number in a column based on other columns OLD INSERTs