Re: [GENERAL] how to do merge in postgres ("with upsert as" not supported)

2015-02-27 Thread Thomas Kellerer
Tong Michael schrieb am 26.02.2015 um 21:23: > > hey, guys, I came across a merge statement when I'm trying to convert stored > procedures from Mysql to Postgres: > > __ __ > > merge into db.ChargePeriod d > using ( > select ba.ClientID > ... > ... That can't be MySQL - MyS

Re: [GENERAL] how to do merge in postgres ("with upsert as" not supported)

2015-02-27 Thread Jim Nasby
On 2/26/15 2:23 PM, Tong Michael wrote: I saw some people use "with upsert as", but my pgAdmin version(1.8) doesn't support it. Anyone has any ideas how to do merge in postgres? Actually, this feature is in active development and will hopefully make it into 9.5. In the meantime, take a l

[GENERAL] how to do merge in postgres ("with upsert as" not supported)

2015-02-26 Thread Tong Michael
hey, guys, I came across a merge statement when I'm trying to convert stored procedures from Mysql to Postgres: merge into db.ChargePeriod d using ( select ba.ClientID , ba.BillingAccountID , bs.BillingScheduleID , @CodeWithholdD as WithholdTypeID from