| From: | momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian) |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: > >Luckily, PG 8 is available for this. |
| Date: | 2005-04-19 03:37:20 |
| Message-ID: | 20050419033720.659D052A77@svr1.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-04-19 03:55:43 | pgsql: >>>>Luckily, PG 8 is available for this. |
| Previous Message | Bruce Momjian | 2005-04-19 03:35:15 | pgsql: The following patch should allow UPDATE_INTERVAL to be specified |