Postgres Pro
Downloads
Home   >   mailing lists

Access to inserted rows via select in a statement - Mailing list pgsql-general

From Jake Stride
Subject Access to inserted rows via select in a statement
Date
Msg-id C93A5FF78A194B07A3FCBA46A600DC4E@stride.me.uk
Whole thread Raw
Responses Re: Access to inserted rows via select in a statement  (David Johnston <polobo@yahoo.com>)
List pgsql-general
Tree view
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 UPDATE as the row exists from a previous insert but not the first time it is called.

Should a SELECT function within a function and a transaction be able to select other rows that have just been inserted in the transaction, but before it is committed?

Thanks
Jake 

-- 
Jake Stride
Find out more http://about.me/jakestride or follow me on twitter @jake.

pgsql-general by date:

Previous
From: Adam Cornett
Date:
Subject: Re: Date Range Using Months and Days Only
Next
From: David Johnston
Date:
Subject: Re: Access to inserted rows via select in a statement