Home > mailing lists

Inserting float with ',' instead of '.' using COPY statement - Mailing list pgsql-general

From	Pier Paolo Bortone
Subject	Inserting float with ',' instead of '.' using COPY statement
Date	October 1, 2001 08:03:15
Msg-id	007401c14a59$9b599a50$6100a8c0@netengineering.it Whole thread Raw
List	pgsql-general

Hi all,

I'm a new user of postgresql. I haven't problem to install and execute postgresql 7.1.3 on my Linux 7.1.

But I don't able to insert a float number with comma separator for decimal, for example:

CREATE TABLE test (

field real

)

INSERT INTO test values ('2,5')\g

ERROR: bad float4 input format

if I write:

INSERT INTO test values ('2.5')\g then all works fine.

Can someone help me to configure postgresql to accept ITALIAN number format?

Thanks in advance at all.

Pier Paolo.

From: J C Lawrence
Date: 01 October 2001, 07:36:46
Subject: GROUP BY with wildcard non-deterministic fields?

From: "Tille, Andreas"
Date: 01 October 2001, 10:20:50
Subject: Re: Performance question (stripped down the problem)