X-Original-To: pgsql-sql@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id E6FBB92618C for ; Sun, 1 Jun 2003 08:21:31 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 98827-03 for ; Sun, 1 Jun 2003 08:21:21 -0400 (EDT) Received: from simmts8-srv.bellnexxia.net (simmts8.bellnexxia.net [206.47.199.166]) by developer.postgresql.org (Postfix) with ESMTP id 05B63925AC4 for ; Sun, 1 Jun 2003 08:21:21 -0400 (EDT) Received: from [192.168.1.200] ([64.231.215.231]) by simmts8-srv.bellnexxia.net (InterMail vM.5.01.05.32 201-253-122-126-132-20030307) with ESMTP id <20030601122121.ZGEU20699.simmts8-srv.bellnexxia.net@[192.168.1.200]>; Sun, 1 Jun 2003 08:21:21 -0400 Subject: Re: generic return for functions From: Rod Taylor To: Avi Schwartz , Bruce Momjian Cc: pgsql-sql@postgresql.org In-Reply-To: <47F83F6F-93EF-11D7-ACB0-000393AE5044@CFFtechnologies.com> References: <47F83F6F-93EF-11D7-ACB0-000393AE5044@CFFtechnologies.com> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-BAS8tzpdUljK1GhUQYOR" Organization: Message-Id: <1054470071.11968.115.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.4 Date: 01 Jun 2003 08:21:12 -0400 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200306/5 X-Sequence-Number: 13763 --=-BAS8tzpdUljK1GhUQYOR Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > thing that causes me some minor grief is the fact that currently you=20 > cannot have default values to function parameters, a feature we use a=20 > lot. The default value is used when the parameter is NULL or unprovided? fn(integer, integer, integer default 32) select fn(integer, integer); <- Third argument would be '32'? When PostgreSQL gets named parameters the above probably makes sense to add. A TODO item? --=20 Rod Taylor PGP Key: http://www.rbt.ca/rbtpub.asc --=-BAS8tzpdUljK1GhUQYOR Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (FreeBSD) iD8DBQA+2e+36DETLow6vwwRArTZAJ9H7CGAWkD8DgOq14UkOf7z+AfutACfXkpB SdiZTo6PFw+IKLkGPYcXdKg= =y70N -----END PGP SIGNATURE----- --=-BAS8tzpdUljK1GhUQYOR--