Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 4BB7A475CBC
	for <pgsql-sql@postgresql.org>; Thu, 30 Jan 2003 04:43:26 -0500 (EST)
Received: from localhost.localdomain (unknown [216.31.142.3])
	by postgresql.org (Postfix) with ESMTP id 5A6F9475AAC
	for <pgsql-sql@postgresql.org>; Thu, 30 Jan 2003 04:43:22 -0500 (EST)
Received: from larubber.com (server [127.0.0.1])
	by localhost.localdomain (8.11.6/8.11.6) with SMTP id h0UAIHP28815
	for <pgsql-sql@postgresql.org>; Thu, 30 Jan 2003 02:18:17 -0800
Received: from 216.86.192.34 (SquirrelMail authenticated user ddurst)
	by www.la-rubber.com with HTTP; Thu, 30 Jan 2003 02:18:17 -0800 (PST)
Message-ID: <33664.216.86.192.34.1043921897.squirrel@www.la-rubber.com>
Date: Thu, 30 Jan 2003 02:18:17 -0800 (PST)
Subject: Question about passing User defined types to functions
From: "David Durst" <ddurst@larubber.com>
To: <pgsql-sql@postgresql.org>
X-Priority: 3
Importance: Normal
X-MSMail-Priority: Normal
Reply-To: ddurst@larubber.com
X-Mailer: SquirrelMail (version 1.2.7)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/494
X-Sequence-Number: 11359

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.