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.