On Fri, Jan 07, 2011 at 09:54:07PM -0600, Nicolas Williams wrote: > On Sat, Jan 08, 2011 at 01:29:23AM +0000, Simon Slavin wrote: > > On 8 Jan 2011, at 1:12am, Nicolas Williams wrote: > > > I need to use recursive triggers. In some cases I want to "normalize" > > > values of some columns of NEW being INSERTed or UPDATEd, but there's no > > > UPDATE syntax for changing NEW, thus I can't write something like: > > > > > > CREATE TRIGGER fred INSTEAD OF INSERT ON myTable ... > > Oh, for some reason I thought that INSTEAD OF triggers were for views > only, but that's not the case. [...]
Actually, I was unable to get SQLite3 to create INSTEAD OF triggers on tables. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
