From: santiago <chetzacoalt@free.fr>
To: pgsql-sql@postgresql.org
Subject: catch an 'update where false' ?
Date: Fri, 12 Aug 2005 17:13:24 +0200
Message-ID: <42FCBC94.1060403@free.fr> (raw)
hello
I' trying to catch un update that fails to update because no row matchs
the where clause:
for instance:
update t set c=1 where cc=2;
--and no row with cc=2
I would like to perform a
insert into t (c) values 1;
before the update is resolved
I hoped a trigger before update could help me, but it seems
that if where clause evals to false, triggers are not called..
someone knows a way around this ?
thanks
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: chetzacoalt@free.fr
Subject: Re: catch an 'update where false' ?
In-Reply-To: <42FCBC94.1060403@free.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox