Re: plpgsql function not accepting NULL value

From: Kenneth Dombrowski <kdombrowski(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: plpgsql function not accepting NULL value
Date: 2005-09-16 23:27:10
Message-ID: d7ba2730509161627635ae030@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 9/16/05, Michael Fuhr <mike(at)fuhr(dot)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)
>
> 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?
>

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2005-09-16 23:27:19 Re: alter sequence + subqueries
Previous Message Alvaro Herrera 2005-09-16 23:19:08 Re: alter sequence + subqueries