postgresql7.1 declare v_product_id integer; begin v_product_id := ec_product__new( :product_id, :user_id, :context_id, :product_name, :price, :sku, :one_line_description, :detailed_description, :search_keywords, :present_p, :stock_status, :dirname, to_date(:available_date, 'YYYY-MM-DD'), :color_list, :size_list, :peeraddr ); update ec_products set style_list = :style_list, email_on_purchase_list = :email_on_purchase_list, url = :url, no_shipping_avail_p = :no_shipping_avail_p, shipping = :shipping, shipping_additional = :shipping_additional, weight = :weight, active_p = 't', template_id = :template_id where product_id = :product_id; return v_product_id; end; now(), :user_id, :peeraddr