postgresql7.1 insert into acs_mail_lite_queue (message_id, to_addr, from_addr, subject, body, extra_headers, bcc, package_id, valid_email_p) values (nextval('acs_mail_lite_id_seq'), :to_addr, :from_addr, :subject, :body, :eh_list, :bcc, :package_id, (case when :valid_email_p = '1' then TRUE else FALSE end)) update acs_mail_lite_mail_log set last_mail_date = current_timestamp where party_id = :user_id insert into acs_mail_lite_mail_log (party_id, last_mail_date) values (:user_id, current_timestamp) select message_id, to_addr, from_addr, subject, body, extra_headers, bcc, package_id, (case when valid_email_p = TRUE then 1 else 0 end) as valid_email_p from acs_mail_lite_queue insert into acs_mail_lite_queue (message_id, to_addr, from_addr, subject, body, extra_headers, bcc, package_id, valid_email_p) values (nextval('acs_mail_lite_id_seq'), :to_addr, :from_addr, :subject, :body, :extraheaders, :bcc, :package_id, (case when :valid_email_p = '1' then TRUE else FALSE end))