Anil Menon wrote: > I would like to ask from your experience which would be the best "generic" > method for checking if row > sets of a certain condition exists in a PLPGSQL function. > > I know of 4 methods so far (please feel free to add if I missed out any > others) [...]
Are you aware that all of these methods have a race condition unless you use isolation level READ STABILITY or better? It may be that rows are added or removed between the check and the corresponding action. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
