>>>>Luckily, PG 8 is available for this. Do you have a short example?
authorBruce Momjian <bruce@momjian.us>
Tue, 19 Apr 2005 03:55:43 +0000 (03:55 +0000)
committerBruce Momjian <bruce@momjian.us>
Tue, 19 Apr 2005 03:55:43 +0000 (03:55 +0000)
commit8262c1bbf11be0f367b60c4f219df1ae18762855
treed50bbf75ff7bed2100da5eec0fd8cb2e0d5d5e35
parent7f6be7f19e730edfb457ac17b564c1ddc79367a1
>>>>Luckily, PG 8 is available for this.  Do you have a short example?
>>>
>>>No, and I think it should be in the manual as an example.
>>>
>>>You will need to enter a loop that uses exception handling to detect
>>>unique_violation.
>>
>>Pursuant to an IRC discussion to which Dennis Bjorklund and
>>Christopher Kings-Lynne made most of the contributions, please find
>>enclosed an example patch demonstrating an UPSERT-like capability.
>>

David Fetter
doc/src/sgml/plpgsql.sgml