Try "SELECT prosrc FROM pg_proc WHERE proname = 'funcname'", where funcname
is the name of the function you want to see.
- Original Message -
From: "stuart" <[EMAIL PROTECTED]>
To: "PG-SQL" <[EMAIL PROTECTED]>
Sent: Tuesday, August 29, 2000 3:20 AM
Subject: Fw: [SQL] Viewing a function
Does it have to be in one row?
Otherwise, assuming that person_data.d_person_id references person.a_id and
person_data.d_attribute_id references person_attribute.a_id:
select a.a_name from person p, person_data d, person_attribute a where
p.p_name = 'UserYou'reLookingFor' AND p.p_id = d.d_person
