Re: [SQL] catch an 'update where false' ?

2005-08-14 Thread santiago
he FOR EACH ROW clause in postgres, and not available in the FOR EACH STATEMENT case. has this changed in some new version ? which shall I use then ? thanks to both ! Alvaro Herrera wrote: > On Fri, Aug 12, 2005 at 05:13:24PM +0200, santiago wrote: > > Triggers FOR EACH ROW are called once

[SQL] catch an 'update where false' ?

2005-08-12 Thread santiago
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, bu