postgresql7.1 select b.bug_id, b.project_id, b.bug_number, b.summary, b.component_id, b.creation_date, to_char(b.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty, b.resolution, b.user_agent, b.found_in_version, b.found_in_version, b.fix_for_version, b.fixed_in_version, to_char(now(), 'fmMM/DDfm/YYYY') as now_pretty from bt_bugs b where b.bug_id = :bug_id select bt_bug_revision__new ( null, :bug_id, :component_id, :found_in_version, :fix_for_version, :fixed_in_version, :resolution, :user_agent, :summary, now(), :creation_user, :creation_ip ); select current_timestamp