pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedNumeric type
2+ messages / 2 participants
[nested] [flat]
* Numeric type
@ 2003-03-18 15:24 Alan Roberto Romaniuc <romaniuc@klais.com.br>
2003-03-18 17:14 ` Re: Numeric type Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Alan Roberto Romaniuc @ 2003-03-18 15:24 UTC (permalink / raw)
To: pgsql-sql
Hi,
Where I live, We have a numeric like ####,### , but postgres default
is a dot (like ####.###).
How can I change that??? A change my locale (to pt_BR) and restarted
postgreql, but it didn work....
Any Help?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Numeric type
2003-03-18 15:24 Numeric type Alan Roberto Romaniuc <romaniuc@klais.com.br>
@ 2003-03-18 17:14 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2003-03-18 17:14 UTC (permalink / raw)
To: Alan Roberto Romaniuc <romaniuc@klais.com.br>; +Cc: pgsql-sql
Alan Roberto Romaniuc <romaniuc@klais.com.br> writes:
> Where I live, We have a numeric like ####,### , but postgres default
> is a dot (like ####.###).
> How can I change that?
I believe the output of to_char() is locale-dependent. The regular
display is not (and shouldn't be, IMHO, because it would make
dump/reload too chancy).
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-03-18 17:14 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-03-18 15:24 Numeric type Alan Roberto Romaniuc <romaniuc@klais.com.br>
2003-03-18 17:14 ` Tom Lane <tgl@sss.pgh.pa.us>
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