Re: Upgrading from 7.1.2 to 7.3.3 - function may need to add explicit typecasts

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stuart Woodward <woodward(at)garage(dot)co(dot)jp>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Upgrading from 7.1.2 to 7.3.3 - function may need to add explicit typecasts
Date: 2003-08-28 03:34:07
Message-ID: 16841.1062041647@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Stuart Woodward <woodward(at)garage(dot)co(dot)jp> writes:
> java.sql.SQLException: ERROR: Function calcprice(numeric, integer, numeric) does not exist

> CREATE FUNCTION calcprice (float8, smallint, float8)

There's no implicit coercion from integer to smallint in 7.3. I'd
suggest changing the function's declared argument type to integer.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-08-28 03:58:11 Re: Returning SETOF INTEGER mystery...
Previous Message Bruno LEVEQUE 2003-08-27 16:56:21 Re: Database names and pg_dump