Re: [GENERAL] Access to inserted rows via select in a statement

2011-10-19 Thread Brett Mc Bride
: 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

Re: [GENERAL] Access to inserted rows via select in a statement

2011-10-19 Thread David Johnston
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

[GENERAL] Access to inserted rows via select in a statement

2011-10-19 Thread Jake Stride
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