[SQL] MySql 'REPLACE'

2001-04-25 Thread Alessio Bragadini
I am working in porting the Slash software from MySql to PostgreSQL. I stepped in MySql's REPLACE command (a SQL command) that to my knowledge is not supported by PostgreSQL and it's not standard SQL. According to MySql's manual: "REPLACE works exactly like INSERT, except that if an old record in

Re: [SQL] MySql 'REPLACE'

2001-04-25 Thread Thomas Good
On Wed, 25 Apr 2001, Alessio Bragadini wrote: > I am working in porting the Slash software from MySql to PostgreSQL. I > stepped in MySql's REPLACE command (a SQL command) that to my knowledge > is not supported by PostgreSQL and it's not standard SQL. According to > MySql's manual: > > "REPLACE

Re: [SQL] MySql 'REPLACE'

2001-04-25 Thread Alessio Bragadini
Thomas Swan wrote: > You should be able to do this with two separate queries inside a > transaction. Yes, sorry, I was not clear enough. Unfortunately, the function I need to write is a "generic" one that takes a number of fields/values and generate a SQL instruction. So, there is no previous in

Re: [SQL] MySql 'REPLACE'

2001-04-26 Thread Thomas Swan
At 4/25/2001 07:38 AM, you wrote: I am working in porting the Slash software from MySql to PostgreSQL. I stepped in MySql's REPLACE command (a SQL command) that to my knowledge is not supported by PostgreSQL and it's not standard SQL. According to MySql's manual: "REPLACE works exactly like INSERT