postgresql7.1
select ec_product__new(
null,
:user_id,
:event_id,
'$activity_info(name) $date_time',
:event_price,
'event_$event_id',
'$activity_info(name); $date_time; $venue_info(city), $venue_info(usps_abbrev)',
'$activity_info(description)',
'$activity_info(name), $venue_info(city), $venue_info(usps_abbrev), $venue_info(venue_name)',
't',
'i',
null,
to_date(current_timestamp, 'YYYY-MM-DD'),
null,
null,
:peeraddr
)
insert into ec_category_product_map values (:product_id, :category_id, null, current_timestamp, :user_id, :peeraddr)