• Bruce Momjian's avatar
    > >Luckily, PG 8 is available for this. Do you have a short example? · bd32a255
    Bruce Momjian authored
    >
    > 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
    bd32a255
plpgsql.sgml 125 KB