Patch applied. Thanks. Sorry for the delay in applying. ---------------------------------------------------------------------------
David Fetter wrote: > On Tue, Mar 08, 2005 at 12:27:21PM +0800, Christopher Kings-Lynne wrote: > > >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. > > Cheers, > D > -- > David Fetter [EMAIL PROTECTED] http://fetter.org/ > phone: +1 510 893 6100 mobile: +1 415 235 3778 > > Remember to vote! [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
