Diehl, Jeffrey writes:
> I'm in the process of migrating a database and application suite from mysql
> to postgresql. The problem is that I've used
> mysql's "replace into..." quite frequently...
begin transaction;
update ...
<if zero rows>
insert ...
<endif>
commit;
or some permutation thereof. If you need to do a lot of this, writing a
PL/pgSQL function might be worthwhile.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/