From: "wade" <[EMAIL PROTECTED]>
> create function get_details(int4) returns details as '
> declare
> ret details%ROWTYPE;
> site_recrecord;
> cntct contacts%ROWTYPE;
> begin
> select into site_rec * sites_table where id = $1 limit 1;
> select into cntct * from contacts where
Here is the senario...
I have a table defined as
create table details (
field1
field2
.
.
.
);
and a function:
create function get_details(int4) returns details as '
declare
ret details%ROWTYPE;
site_recrecord;
cntct contacts%ROWTYPE;
begin
select
Here is the senario...
I have a table defined as
create table details (
field1
field2
.
.
.
);
and a function:
create function get_details(int4) returns details as '
declare
ret details%ROWTYPE;
site_recrecord;
cntct contacts%ROWTYPE;
begin
select
