Question about passing User defined types to functions - Mailing list pgsql-sql

From David Durst
Subject Question about passing User defined types to functions
Date
Msg-id 33664.216.86.192.34.1043921897.squirrel@www.la-rubber.com
Whole thread Raw
Responses Re: Question about passing User defined types to functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
is there a example on how to pass user defined types into
a function??

What I am looking for is something of this nature.

CREATE TYPE dumby_type AS (dumby_id int4, dumby_name text);

create function kick_dumby(dumby dumby_type) returns INTEGER AS '
DECLARE somenumber integer;
BEGIN return 1;
END;
' language 'plpgsql';


Is there some way of doing this, because the above doesn't work.




pgsql-sql by date:

Previous
From: Tony Simbine
Date:
Subject: Re: help: triggers
Next
From: val@webtribe.net
Date:
Subject: Delete 1 Record of 2 Duplicate Records