Access to inserted rows via select in a statement

[Jake Stride <jake@xxxxxxxxxxxx>]

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.