pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Kaare Rasmussen <kar@kakidata.dk>
To: pgsql-sql@postgresql.org
Subject: to_number
Date: Sun, 30 Mar 2003 14:54:29 +0200
Message-ID: <200303301454.30758.kar@kakidata.dk> (raw)

# SELECT * FROM pg_settings WHERE name LIKE 'lc_%';
    name     | setting
-------------+---------
 lc_messages | unset
 lc_monetary | C
 lc_numeric  | C
 lc_time     | C
(4 rows

SELECT price, to_number(price,'9999D9)') FROM orderline WHERE sku = 
'01-0082-4';
 price | to_number
-------+-----------
 429,5 |      4295
 429,5 |      4295
 429,5 |      4295
 429,5 |      4295
 429,5 |      4295
 429,5 |      4295
 429,5 |      4295
 429,5 |      4295
 429,5 |      4295
 429,5 |      4295
(10 rows)

How can to_number work with Danish locale?

-- 
Kaare Rasmussen            --Linux, spil,--        Tlf:        3816 2582
Kaki Data                tshirts, merchandize      Fax:        3816 2501
Howitzvej 75               Åben 12.00-18.00        Email: kar@kakidata.dk
2000 Frederiksberg        Lørdag 12.00-16.00       Web:      www.suse.dk

view thread (5+ messages)  latest in thread

Message-ID: <200303301454.30758.kar@kakidata.dk>
Permalink:  ../200303301454.30758.kar@kakidata.dk/
Also on:    postgresql.org/message-id/200303301454.30758.kar@kakidata.dk

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: kar@kakidata.dk
  Subject: Re: to_number
  In-Reply-To: <200303301454.30758.kar@kakidata.dk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox