postgresql 7.1 insert into ec_orders (order_id, user_session_id, order_state, in_basket_date) select :order_id, :user_session_id, 'in_basket', current_timestamp where not exists (select 1 from ec_orders where user_session_id=:user_session_id and order_state='in_basket') insert into ec_problems_log (problem_id, problem_date, problem_details) values (ec_problem_id_sequence.nextval, current_timestamp,:errormsg) insert into ec_items (item_id, product_id, color_choice, size_choice, style_choice, order_id, in_cart_date) select ec_item_id_sequence.nextval, :product_id, :color_choice, :size_choice, :style_choice, :order_id, current_timestamp from dual