String to float conversion
От | raffaele.lazzaro@tiscali.it |
---|---|
Тема | String to float conversion |
Дата | |
Msg-id | 4212FD70000758D9@mail-2.tiscali.it обсуждение исходный текст |
Список | pgsql-novice |
Hi, I have a "little" problem with data insertion. Suppose I have a table with a column real for exemple: CREATE TABLE number (value real); I want to do something like this insert into number(value)values('123,5'); but this raise an error because the comma is interpreted not as decimal separator (the error is "invalid input syntax for type real" ). I have already tryed to localize all configuration in postgresql.conf. Those are configurations I have setted: # - Locale and Formatting - datestyle = 'european' #timezone = unknown # actually, defaults to TZ environment setting #australian_timezones = false #extra_float_digits = 0 # min -15, max 2 #client_encoding = sql_ascii # actually, defaults to database encoding # These settings are initialized by initdb -- they might be changed lc_messages = 'Italian_Italy.1252' # locale for system error message strings lc_monetary = 'Italian_Italy.1252' # locale for monetary formatting lc_numeric = 'Italian_Italy.1252' # locale for number formatting lc_time = 'Italian_Italy.1252' # locale for time formatting I have already tried to re execute the initdb but still not works. So can be changed the be behaviour of the string parser? How can I set a default behaviour to parse the comma as a decimal separator? Note that I cannot known (whe I ran the insert query) the type of the column. Thanks to all Luca __________________________________________________________________ Tiscali Adsl 3 Mega Flat con 3 MESI GRATIS! Con Tiscali Adsl 3 Mega Flat navighi con la Supervelocita' a soli 29.95 euro al mese, senza limiti di tempo. E se attivi entro il 31 Marzo, 3 MESI sono GRATIS! Scopri come su http://abbonati.tiscali.it/adsl/sa/2flat_tc/
В списке pgsql-novice по дате отправления: