"Marc Mamin" <[EMAIL PROTECTED]> writes:
> Can I optimize this function with:
> a) remove the EXCEPTION clause (Is there an underlying lock that prevent
> concurrent inserts ?)
No.
> b) declare the function being IMMUTABLE ?
Certainly not --- it's got side-effects.
rega
Hello,
I have a simple table id/value, and a function that returns the id of a
given value, inserting the later if not yet present. The probability
that a value already exist within the reference table is very high.
Different db users may have their own reference table with different
content, bu
