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]

Reply via email to