Postgres Pro
Downloads
Home   >   mailing lists

allowing ',' (comma) in float8 - Mailing list pgsql-novice

From stig erikson
Subject allowing ',' (comma) in float8
Date
Msg-id d8h227$u28$1@news.hub.org
Whole thread Raw
Responses Re: [despammed] allowing ',' (comma) in float8
Re: allowing ',' (comma) in float8
List pgsql-novice
Tree view 
hi.
is it possible to use flort values with a comma as decimal placeholder?

i am trying to use copy to insert a table, the table contains a few columns with
numerical values such as price, the vales are given on the format "2345,12",
postgresql seems to allow only "2345.12".

can i change the behavior on postgresql to allow ',' as decimal placeholder?

postgresql 7.4.6

/stig

pgsql-novice by date:

Previous
From: Sophie Yang
Date:
Subject: Set Membership operator -- test group membership
Next
From: Michael Fuhr
Date:
Subject: Re: Storing an array to Postgresql table