New answers tagged duplication
I have re-tested your function and it seems to work as advertised. If, in fact a duplicate value was entered, you would get an exception that would roll back the transaction. The function is designed to trap such an exception (UNIQUE_VIOLATION) and to try again, which would find the (now) existing row and return the existing id. Your report of ...
Top 50 recent answers are included