postgresql7.4 select dotfolio__new ( null, -- dotfolio_id, :owner_id, :node_id, :package_id, :username, current_timestamp, -- creation_date :user_id, :peeraddr, -- creation_ip, null -- context_id ) UPDATE cr_items SET live_revision=latest_revision WHERE item_id=:welcome_content_id SELECT first_names, last_name FROM dotfolio_users WHERE user_id = :owner_id SELECT dotfolio__has_p(:user_id) AS has_dotfolio_p SELECT group_id FROM dotfolio_user_types WHERE type = :user_type SELECT t.pretty_name FROM acs_object_types t, acs_objects o WHERE o.object_id = :object_id AND t.object_type = o.object_type