Postgres Pro
Downloads
Home   >   mailing lists

HELP: Insert FLOAT in ITALIAN format. - Mailing list pgsql-admin

From Pier Paolo Bortone
Subject HELP: Insert FLOAT in ITALIAN format.
Date
Msg-id 010a01c14a87$cdff5e30$6100a8c0@netengineering.it
Whole thread Raw
List pgsql-admin
Tree view
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.

pgsql-admin by date:

Previous
From: "Dave Johnson"
Date:
Subject: reteptools.jar
Next
From: marc@oscar.eng.cv.net (Marc Spitzer)
Date:
Subject: Re: moving user obejcts to production