First, you should not quote an integer value going into an integer column - bad habit to get into.
Second, empty string is not an integer.
Susan
"surabhi.ahuja"
<[EMAIL PROTECTED] To:
<pgsql-general@postgresql.org>
.in> cc:
Sent by: Subject: [GENERAL] a
stored procedure ..with integer as the parameter
|-------------------|
[EMAIL PROTECTED] | [ ] Expand Groups |
tgresql.org |-------------------|
10/20/2005 11:03
PM
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
thanks,
reagrds
surabhi
----------------------------------------------------------------------------------------------
See our award-winning line of tape and disk-based
backup & recovery solutions at http://www.overlandstorage.com
----------------------------------------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
