Re: plpgsql function not accepting NULL value

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Kenneth Dombrowski <kdombrowski(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: plpgsql function not accepting NULL value
Date: 2005-09-16 23:18:35
Message-ID: 20050916231835.GA88542@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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)

You've created a function with six arguments.

> invoicer=> 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

You've called a function with seven arguments. Which is it supposed
to be?

--
Michael Fuhr

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Alvaro Herrera 2005-09-16 23:19:08 Re: alter sequence + subqueries
Previous Message Stephan Szabo 2005-09-16 23:17:21 Re: plpgsql function not accepting NULL value