allowing ',' (comma) in float8

From: stig erikson <stigerikson_nospam_(at)yahoo(dot)se>
To: pgsql-novice(at)postgresql(dot)org
Subject: allowing ',' (comma) in float8
Date: 2005-06-12 10:17:12
Message-ID: d8h227$u28$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Verena Ruff 2005-06-12 21:44:08 Inheritance, foreign key constraint
Previous Message Bruno Wolff III 2005-06-11 02:36:26 Re: accessing data from other databases?