Re: [HACKERS] Merge condition in postgresql

2008-02-04 Thread Martijn van Oosterhout
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

Re: [HACKERS] Merge condition in postgresql

2008-02-04 Thread Roberts, Jon
> -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-hackers- > [EMAIL PROTECTED] On Behalf Of Stephen Frost > Sent: Monday, February 04, 2008 8:28 AM > To: Amit jain > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Merge condition in postgresql >

Re: [HACKERS] Merge condition in postgresql

2008-02-04 Thread Stephen Frost
* Amit jain ([EMAIL PROTECTED]) wrote: > I am currently migrating database from ORACLE to postgresql but i am stucked > up at one point while creating procedures. > There is a query which has used oracle MERGE condition so how can i change > this query as per posgresql. kindly suggest me its very u

[HACKERS] Merge condition in postgresql

2008-02-04 Thread Amit jain
Hello All, I am currently migrating database from ORACLE to postgresql but i am stucked up at one point while creating procedures. There is a query which has used oracle MERGE condition so how can i change this query as per posgresql. kindly suggest me its very urgent.