Hello list.
We are migrating from Informix to PSQL.
In Informix we used to do:
- BEGIN WORK
- INSERT ROW
- IF FAILED THEN UPDATE ROW
- COMMIT WORK
In PSQL this does not seem to work because after the first error (the
insert)
everything is omitted.
Has someone found a solution for this (we have 1000's of this type).
Henk Sanders