Re: Merge condition in postgresql - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: Merge condition in postgresql
Date
Msg-id 20080204160950.GB17150@svana.org
Whole thread Raw
In response to Re: Merge condition in postgresql  ("Roberts, Jon" <Jon.Roberts@asurion.com>)
List pgsql-hackers
On Mon, Feb 04, 2008 at 09:44:17AM -0600, Roberts, Jon wrote:
> If you guys develop Merge for PostgreSQL, I highly suggest putting an
> "order by" statement in the syntax so if the source has duplicates, it
> will insert the first one and then do subsequent updates.

I don't think it would meet the standard definition then. The statement
shouldn't be able to to see the effects of itself...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Page-at-a-time Locking Considerations
Next
From: Andrew Dunstan
Date:
Subject: release checklist