If in a transaction I call an embedded function in Pl/PgSQL, in which I have:
delete from t where condition; for e in select distinct on (f) * from t where ... loop ... end loop; Do I have the guarantee that, in any event, rows deleted from table t by the delete won't reappear in the select result? Sam -- Samuel Tardieu -- [EMAIL PROTECTED] -- http://www.rfc1149.net/sam ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]