On Wed, Feb 15, 2012 at 5:26 PM, Bartosz Dmytrak <bdmytrak@xxxxxxxxx> wrote: > Hi, > similar topic is in NOVICE mailing > list: http://archives.postgresql.org/pgsql-novice/2012-02/msg00034.php > > e.g. You can use BEGIN... EXCEPTION.... END, good example of > such approach is > there: http://www.postgresql.org/docs/9.1/static/plpgsql-control-structures.html#PLPGSQL-UPSERT-EXAMPLE; Ah, thanks for that! Currently the query is a single PHP pg_query_params() call, and it's inside a larger transaction. By the look of it, this requires writing a function to do the job, rather than embedding the logic straight into the query - is this correct? ChrisA -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
