Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] float4 confused as int??

From: Jose Soares <jose(at)sferacarta(dot)com>
To: Ed Loehr <eloehr(at)austin(dot)rr(dot)com>
Cc: pg-gen <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] float4 confused as int??
Date: 2000-01-31 13:29:04
Message-ID: 38958E20.6C517510@sferacarta.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
What version are you running?
I tried it on 6.5.2 and it works.

Ed Loehr wrote:

> Can someone enlighten me why this error is occurring in which a float
> value is apparently being interpreted as an integer?  Known
> workarounds??
>
> emsdb=>   UPDATE contract_activity_type SET duration = 3.5, updater_id
> = 1, last_update = now() WHERE id = 72;
> ] ERROR:  pg_atoi: error in "3.5": can't parse ".5"
> emsdb=> \d contract_activity_type
> Table    = contract_activity_type
> +----------------------------------+----------------------------------+-------+
> |              Field               |              Type
> | Length|
> +----------------------------------+----------------------------------+-------+
> | id                               | int4 not null default nextval (
> |     4 |
> | contract_id                      | int4 not null
> |     4 |
> | activity_type_id                 | int4 not null
> |     4 |
> | travel_required                  | int4 not null
> |     4 |
> | billable                         | int4 not null
> |     4 |
> | duration                         | float4 not null
> |     4 |
>
> Thanks in advance.
>
> Cheers,
> Ed Loehr
>
> ************

--
Jose' Soares
Bologna, Italy                     Jose(at)sferacarta(dot)com



In response to

pgsql-hackers by date

Next:From: The Hermit HackerDate: 2000-01-31 13:36:26
Subject: Re: [HACKERS] freefuncs.c is never called from anywhere!?
Previous:From: Peter EisentrautDate: 2000-01-31 13:14:11
Subject: Re: Case-folding bogosity in new psql

pgsql-general by date

Next:From: Fabian.FrederickDate: 2000-01-31 13:34:41
Subject: unsubscribe
Previous:From: Marc TardifDate: 2000-01-31 12:09:58
Subject: ERROR: RelationCatalogInformation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group