On Wed, 4 Apr 2001, Steven Vajdic wrote:
>
> Dear all,
>
> I've migrated from RedHat6.2/PHP3.0/PostgreSQL6.5 to
> Mandrake/PHP4.0/Postgres7.0.2 successfully as far as
> pg_dump database_name is concerned.
>
> I am still running BOTH versions on two computers.
>
> PostgreSQL6.5 does not produce any error using math function "integer
> (float_expression)"
> (even "int(float_expression" is OK with 6.5)
> and 7.0.2 complains saying:
>
> "function integer(float8) is not found for specified types"
>
Try using int2()/int4()/int8() instead of integer(). The intn() functions
convert the float to a integer n bytes long, in normal cases you probably
want to use int4().
- Einar