Here is the senario...
I have a table defined as
create table details (
field1 <type>
field2 <type>
.
.
.
);
and a function:
create function get_details(int4) returns details as '
declare ret details%ROWTYPE; site_rec record; cntct contacts%ROWTYPE;
begin select into site_rec * sites_table where id = $1 limit 1; select into cntct * from contacts where id =
site_rec.contact;
-- and then i populate rows of ret. ret.name := cntct.name; ret.ip := site_rec.ip;
.
.
. return ret;
end;
' language 'plpgsql';
now the problem is when is when I do a: SELECT get_details(55);
all i get is a single oid-looking return value:get_details
-------------136295592
(1 row)
How do i get at the actual information in the row?
Is this type of function even possible?
If not, is there a different manner in which i should approach this task?
Thanx in advance.-Wade
