: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David Johnston
Sent: Thursday, 20 October 2011 10:49 AM
To: Jake Stride
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Access to inserted rows via select in a statement
On Oct 19, 2011, at 19:17, Jake
On Oct 19, 2011, at 19:17, Jake Stride wrote:
> I am writing a function that is called by a trigger after insert and update
> but it is not returning all the rows I want it to with a SELECT.
>
> This trigger is called within a transaction and looks for a row inserted
> previously within the sa
I am writing a function that is called by a trigger after insert and update but
it is not returning all the rows I want it to with a SELECT.
This trigger is called within a transaction and looks for a row inserted
previously within the same transaction - it works when the trigger is called
via