[SQL] Problem with SQL query (eats swap)

2000-08-10 Thread Mailing List Expander
Hi, I have two tables into which I dump mail statistics. The two tables are: create table attachments ( id text, attachment text ); create table mail ( id text, size int, whofrom text, subject text, date datetime, inout char ); The table mail holds information about each mail me

Re: [SQL] Rules aren't doing what I expect

2000-08-10 Thread Mark Volpe
The actual trigger function I'm working with is over two screens long and rather expensive to be calling twice! Perhaps I need to add another trigger that updates the log table with the correct values after the fact. Recursive triggers, fun! Thanks for the help, Mark Ang Chin Han wrote: > > Eit