postgresql 7.1 select site_node__url(s.node_id) from site_nodes s, apm_packages a where s.object_id = a.package_id and a.package_key = 'ecommerce' select site_node__url(s.node_id) from site_nodes s, apm_packages a where s.object_id = a.package_id and a.package_key = '$package_key' select c.one_line_summary, c.rating, c.user_comment, to_char(c.last_modified,'Day Month DD, YYYY') as last_modified_pretty, u.email, u.user_id from ec_product_comments c, cc_users u where c.user_id = u.user_id and c.product_id = :product_id $end_of_comment_query select case when current_timestamp > available_date then 1 when current_timestamp-available_date is NULL then 1 else 0 end as available_p, color_list, size_list, style_list, no_shipping_avail_p from ec_products where product_id = :product_id select to_char(available_date,'Month DD, YYYY') available_date from ec_products where product_id = :product_id insert into ec_user_sessions (user_session_id, ip_address, start_time, http_user_agent) values (:user_session_id, :ip_address, current_timestamp, :http_user_agent)