[HACKERS] float4 confused as int??

Поиск
Список
Период
Сортировка
От Ed Loehr
Тема [HACKERS] float4 confused as int??
Дата
Msg-id 38951455.28A436A@austin.rr.com
обсуждение исходный текст
Ответы Re: [HACKERS] float4 confused as int??  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Another nasty cache problem
Следующее
От: wieck@debis.com (Jan Wieck)
Дата:
Сообщение: Re: [HACKERS] END/ABORT