[GENERAL] float4 confused as int??

Поиск
Список
Период
Сортировка
От Ed Loehr
Тема [GENERAL] float4 confused as int??
Дата
Msg-id 3894B51F.A9D35D2D@austin.rr.com
обсуждение исходный текст
Список pgsql-general
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-general по дате отправления:

Предыдущее
От: Matthew Dormer
Дата:
Сообщение: Error Updating Records.
Следующее
От: "slamet pramono"
Дата:
Сообщение: subscribe