plpgsql rowtype

From: Heiko(dot)Kehlenbrink(at)vermes(dot)fh-oldenburg(dot)de
To: pgsql-novice(at)postgresql(dot)org
Subject: plpgsql rowtype
Date: 2003-06-26 09:47:47
Message-ID: 1056620867.3efac143ca65d@mail-ole.fh-oldenburg.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message christoph.dellavalle 2003-06-26 12:09:17 postmaster generates no socket
Previous Message Josh Berkus 2003-06-26 06:12:08 Re: Restoring an existing database