Обсуждение: pgsql: > >Luckily, PG 8 is available for this.

Поиск
Список
Период
Сортировка

pgsql: > >Luckily, PG 8 is available for this.

От
momjian@svr1.postgresql.org (Bruce Momjian)
Дата:
Log Message:
-----------
> >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

Modified Files:
--------------
    pgsql/doc/src/sgml:
        plpgsql.sgml (r1.65 -> r1.66)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/plpgsql.sgml.diff?r1=1.65&r2=1.66)