"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, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to