X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 02D30D91F9
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 16 Sep 2005 20:27:11 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 02045-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 16 Sep 2005 23:27:06 +0000 (GMT)
Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.205])
	by svr1.postgresql.org (Postfix) with ESMTP id 916F6D91E6
	for <pgsql-sql@postgresql.org>; Fri, 16 Sep 2005 20:27:06 -0300 (ADT)
Received: by zproxy.gmail.com with SMTP id 40so150362nzk
	for <pgsql-sql@postgresql.org>; Fri, 16 Sep 2005 16:27:10 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=iRpY+INAH7PNH+/1DA2rX/fSsabUhB12WRCFB4JvbBiFRkA2Mmf5NVFA4NVadUbV8QrauDeRFXvU34wpdPPwE3dIxZPsZMFNVE6qsic9rdExXUkWSQ/rLFzTbJHviu90KjvtinJZxqz4YMwAztVBbM5zjcxTJQtkcrlY/G5VCBs=
Received: by 10.36.46.15 with SMTP id t15mr104469nzt;
	Fri, 16 Sep 2005 16:27:10 -0700 (PDT)
Received: by 10.36.103.16 with HTTP; Fri, 16 Sep 2005 16:27:10 -0700 (PDT)
Message-ID: <d7ba2730509161627635ae030@mail.gmail.com>
Date: Fri, 16 Sep 2005 19:27:10 -0400
From: Kenneth Dombrowski <kdombrowski@gmail.com>
Reply-To: kdombrowski@gmail.com
To: pgsql-sql@postgresql.org
Subject: Re: plpgsql function not accepting NULL value
In-Reply-To: <20050916231835.GA88542@winnie.fuhr.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <d7ba27305091616046e23e171@mail.gmail.com>
	<20050916231835.GA88542@winnie.fuhr.org>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.024 required=5 tests=[RCVD_BY_IP=0.024]
X-Spam-Level: 
X-Archive-Number: 200509/170
X-Sequence-Number: 22717

On 9/16/05, Michael Fuhr <mike@fuhr.org> wrote:
> On Fri, Sep 16, 2005 at 07:04:39PM -0400, Kenneth Dombrowski wrote:
> > create or replace function update_rate (integer, integer, integer,
> >         integer, numeric, integer)
>=20
> You've created a function with six arguments.
>=20
> > invoicer=3D> select update_rate(1, 1, 10, NULL, numeric '90.00', 6, 216=
);
> > ERROR:  function update_rate(integer, integer, integer, "unknown",
> > numeric, integer, integer) does not exist
>=20
> You've called a function with seven arguments.  Which is it supposed
> to be?
>=20

Ahhhhhh... thanks to both of you.  My eyes are tired.