Re: [HACKERS] Best practices: MERGE

Thanks, fixed.

---------------------------------------------------------------------------

Christopher Kings-Lynne wrote:
> Is that broken?
>
> http://momjian.postgresql.org/main/writings/pgsql/sgml/build.html
>
> Chris
>
> Bruce Momjian wrote:
> > 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 david(at)fetter(dot)org 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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073