mysql's "replace into..." - Mailing list pgsql-sql

From Diehl, Jeffrey
Subject mysql's "replace into..."
Date
Msg-id B51F0C636E578A4E832D3958690CD73E0130BE49@es04snlnt
Whole thread Raw
List pgsql-sql
Hi all,

I'm in the process of migrating a production database and related
applicatoins from mysql to postgresql.  I've just not been very impressed
with mysql's stability, that is I'm trying to make my phone stop ringing.

However, when I wrote the applications, I took free advantage of mysql's
replace into feature which behaves like a smart insert that inserts new
records or updates old records.  I'm using perl DBI and need to figure out a
good way to migrate this to postgresql. 

Any ideas?

Mike Diehl.



pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Debug messages in beta5
Next
From: Josh Berkus
Date:
Subject: Updatable Views