postgresql7.4
SELECT pref_name, tele_work, tele_home, mobile,
im_msn, im_aim, interests, company, job_desc,
goals, edu_level, university, main_skills
FROM dotfolio_owner_identification
WHERE owner_id = :owner_id
SELECT dotfolio_owner_identification__new (:owner_id, :pref_name,
:tele_work, :tele_home, :mobile, :im_msn, :im_aim,
:interests, :company, :job_desc, :goals, :edu_level,
:university, :main_skills)
UPDATE dotfolio_owner_identification SET
pref_name = :pref_name,
tele_work = :tele_work,
tele_home = :tele_home,
mobile = :mobile,
im_msn = :im_msn,
im_aim = :im_aim,
interests = :interests,
company = :company,
job_desc = :job_desc,
goals = :goals,
edu_level = :edu_level,
university = :university,
main_skills = :main_skills
WHERE
owner_id = :owner_id
SELECT 1 FROM dotfolio_owner_identification WHERE owner_id = :owner_id