postgresql 7.1 select ec_issue_id_sequence.nextval insert into ec_customer_serv_interactions (interaction_id, customer_service_rep, user_identification_id, interaction_date, interaction_originator, interaction_type, interaction_headers) values (:interaction_id, :customer_service_rep, :user_identification_id, current_timestamp, :interaction_originator, :interaction_type, :interaction_headers) insert into ec_customer_service_issues (issue_id, user_identification_id, order_id, open_date, close_date, closed_by, gift_certificate_id) values (:issue_id, :user_identification_id, :order_id, current_timestamp, current_timestamp, :customer_service_rep, :gift_certificate_id) select i.issue_id, i.open_date, i.close_date, m.issue_type from ec_user_identification id, ec_customer_service_issues i left join ec_cs_issue_type_map m on (i.issue_id = m.issue_id) where i.user_identification_id = id.user_identification_id and id.user_id = :user_id order by i.issue_id select i.issue_id, i.open_date, i.close_date, m.issue_type from ec_customer_service_issues i left join ec_cs_issue_type_map m on (i.issue_id = m.issue_id) where i.user_identification_id = :user_identification_id order by i.issue_id