| From: | Einar Karttunen <ekarttun(at)cs(dot)Helsinki(dot)FI> |
|---|---|
| To: | <svajdic(at)asc(dot)corp(dot)mot(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Is this a bug in 7.0.2? |
| Date: | 2001-04-04 07:11:21 |
| Message-ID: | Pine.LNX.4.30.0104041007350.1626-100000@tankar-11.cs.Helsinki.FI |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Einar Karttunen | 2001-04-04 07:16:40 | Re: tuple too big error |
| Previous Message | Richard Huxton | 2001-04-04 07:11:10 | Re: tuple too big error |