HELP: Insert FLOAT in ITALIAN format.

From: "Pier Paolo Bortone" <pierpaolo(dot)bortone(at)netengineering(dot)it>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: HELP: Insert FLOAT in ITALIAN format.
Date: 2001-10-01 14:46:06
Message-ID: 010a01c14a87$cdff5e30$6100a8c0@netengineering.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Browse pgsql-admin by date

  From Date Subject
Next Message Trewern, Ben 2001-10-01 15:12:54 Re: Reporting Tool?
Previous Message Justin Clift 2001-10-01 13:40:44 Re: Reporting Tool?