Received: from ns.krot.org (ns.krot.org [193.212.103.165]) by postgresql.org (8.11.3/8.11.4) with SMTP id fAPJemm11978 for ; Sun, 25 Nov 2001 14:40:48 -0500 (EST) (envelope-from postgresql@envisity.com) Received: (qmail 7565 invoked by uid 67); 25 Nov 2001 19:39:40 -0000 Message-ID: <20011125193940.27682.qmail@ns.krot.org> Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline MIME-Version: 1.0 From: "Aasmund Midttun Godal" To: mindterm@yahoo.com Cc: pgsql-sql@postgresql.org Subject: Re: How to create function with unspecified number of input Date: Sun, 25 Nov 2001 19:39:40 GMT X-Mailer: Googley-Moogley In-Reply-To: <20011125042521.54480.qmail@web20202.mail.yahoo.com> from Mindterm on Sat, 24 Nov 2001 20:25:21 -0800 (PST) References: <20011125042521.54480.qmail@web20202.mail.yahoo.com> Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id fAPK3Dn13642 X-Archive-Number: 200111/357 X-Sequence-Number: 5739 Perhaps you could pass an array into it instead? Regards, Aasmund. On Sat, 24 Nov 2001 20:25:21 -0800 (PST), MindTerm wrote: > Dear all, > > I am writing to ask how to create function ( CREATE > FUNCTION ) with unspecified number of input parameters > ? e.g. I like to create a function similar to the > structure of COALESCE : > > COALESCE( ... , [..] ) > > M.T. > > > > __________________________________________________ > Do You Yahoo!? > Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. > http://geocities.yahoo.com/ps/info1 > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster Aasmund Midttun Godal aasmund@godal.com - http://www.godal.com/ +47 40 45 20 46