X-Original-To: pgsql-sql@postgresql.org Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 3C31F475A4B for ; Tue, 18 Mar 2003 12:14:51 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.8/8.12.8) with ESMTP id h2IHEoub020183; Tue, 18 Mar 2003 12:14:51 -0500 (EST) To: Alan Roberto Romaniuc Cc: pgsql-sql@postgresql.org Subject: Re: Numeric type In-reply-to: <3E773A13.706@klais.com.br> References: <3E773A13.706@klais.com.br> Comments: In-reply-to Alan Roberto Romaniuc message dated "Tue, 18 Mar 2003 12:24:03 -0300" Date: Tue, 18 Mar 2003 12:14:50 -0500 Message-ID: <20182.1048007690@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200303/439 X-Sequence-Number: 12478 Alan Roberto Romaniuc 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