postgresql7.1
update ec_sales_tax_by_state
set tax_rate=:state_tax_rate,
shipping_p=:ship_status,
last_modified=current_timestamp,
last_modifying_user=:user_id,
modified_ip_address=:ip_addr
where usps_abbrev=:usps_abbrev
insert into ec_sales_tax_by_state
(usps_abbrev, tax_rate, shipping_p, last_modified, last_modifying_user, modified_ip_address)
values
(:usps_abbrev, :state_tax_rate, :ship_status, current_timestamp, :user_id, :ip_addr)