Skip site navigation (1) Skip section navigation (2)

Re: [despammed] allowing ',' (comma) in float8

From: Andreas Kretschmer <akretschmer(at)despammed(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [despammed] allowing ',' (comma) in float8
Date: 2005-06-19 07:23:54
Message-ID: 20050619072354.GA5754@webserv.wug-glas.de (view raw or flat)
Thread:
Lists: pgsql-novice
am  12.06.2005, um 12:17:12 +0200 mailte stig erikson folgendes:
> 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".

You can pipe the input-file thru tools like sed ore awk and substitute
',' with '.'. This is simple.


Regards, Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    === 

In response to

Responses

pgsql-novice by date

Next:From: Andreas KretschmerDate: 2005-06-19 07:58:45
Subject: Re: [despammed] allowing ',' (comma) in float8
Previous:From: Michael FuhrDate: 2005-06-19 05:27:26
Subject: Re: Storing an array to Postgresql table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group