plpgsql rowtype - Mailing list pgsql-novice

From Heiko.Kehlenbrink@vermes.fh-oldenburg.de
Subject plpgsql rowtype
Date
Msg-id 1056620867.3efac143ca65d@mail-ole.fh-oldenburg.de
Whole thread Raw
Responses Re: plpgsql rowtype
List pgsql-novice
hi all,

i want to proof if if a rowtype has an attribute or get all attribute of a rowtype.

like:



CREATE OR REPLACE FUNCTION "test"() RETURNS varchar AS '
DECLARE

rs_refr_row rs_refr%ROWTYPE;


begin



if ( proofing if rs_feat_row.id exists ) then
select 1 into rs_feat_row.id;
end if;



RETURN rs_feat_row.id::varchar ;
end;
' LANGUAGE 'plpgsql'

best regards

heiko kehlenbrink


pgsql-novice by date:

Previous
From: Nabil Sayegh
Date:
Subject: Re: Fw: Removing foreign key and adding sequence
Next
From: Nabil Sayegh
Date:
Subject: Re: Probably a stupid question