Postgres Pro
Downloads
Home   >   mailing lists

Re: Upgrading from 7.1.2 to 7.3.3 - function may need to add explicit typecasts - Mailing list pgsql-novice

From Tom Lane
Subject Re: Upgrading from 7.1.2 to 7.3.3 - function may need to add explicit typecasts
Date
Msg-id 16841.1062041647@sss.pgh.pa.us
Whole thread Raw
In response to Upgrading from 7.1.2 to 7.3.3 - function may need to add explicit typecasts  (Stuart Woodward <woodward@garage.co.jp>)
List pgsql-novice
Tree view 
Stuart Woodward <woodward@garage.co.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

pgsql-novice by date:

Previous
From: Juan Francisco Diaz
Date:
Subject: Returning a setof integer
Next
From: Tom Lane
Date:
Subject: Re: Returning SETOF INTEGER mystery...