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,
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.
regards,