Re: a stored procedure ..with integer as the parameter

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: a stored procedure ..with integer as the parameter
Date: 2005-10-21 06:41:54
Message-ID: 20051020233951.A7227@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 21 Oct 2005, surabhi.ahuja wrote:

> i have a stored procedure
>
> insert_table(integer)
> which does "insert into table (x) value ($1)";
>
> now in my client i call the stored procedure as
>
> select insert_table("3");
>
> it works fine and inserts 3 into the table
>
> but suppose i give
>
> select insert_table("");
>
> it gives an error ...saying " invalid input syntax for integer: "
>
> please suggest a solution to this problem

Don't try to use an empty string as an integer?

Seriously, you need to give information about what you want to happen,
because an empty string isn't a valid integer and can't really be
converted into one (we explicitly removed code that handled this case
because we thought it didn't make sense).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hannes Dorbath 2005-10-21 07:14:00 Re: Tutorials in FreeBSD
Previous Message surabhi.ahuja 2005-10-21 06:03:54 a stored procedure ..with integer as the parameter