Re: [GENERAL] Multi-row update w. plpgsql function

2005-12-14 Thread Daniel Hertz
Aaron Koning wrote: This might be easier to use this SQL: UPDATE message_table SET status = 'A' WHERE mid IN (1,2,3); The following might work for Cocoon (never used it): UPDATE message_table SET status = 'A' WHERE mid IN (); Aaron On 12/13/05, Daniel Hertz <[EMAIL PROTECTED]> wrot

Re: [GENERAL] Multi-row update w. plpgsql function

2005-12-13 Thread Aaron Koning
This might be easier to use this SQL: UPDATE message_table SET status = 'A' WHERE mid IN (1,2,3); The following might work for Cocoon (never used it): UPDATE message_table SET status = 'A' WHERE mid IN (); Aaron On 12/13/05, Daniel Hertz <[EMAIL PROTECTED]> wrote: Given a set of checkb