OSDN Git Service

> >Luckily, PG 8 is available for this. Do you have a short example?
authorBruce Momjian <bruce@momjian.us>
Tue, 19 Apr 2005 03:37:20 +0000 (03:37 +0000)
committerBruce Momjian <bruce@momjian.us>
Tue, 19 Apr 2005 03:37:20 +0000 (03:37 +0000)
commitbd32a2559873030020c7b4324ba2fbb4026d43d5
tree26d51707a03a1c2b64bd770363df54499cffc4ed
parent7cce39c7ce8bf9188996bb7483e8a41fd6dfab8e
> >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