Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 2F2199FACFE for ; Sun, 21 Jan 2007 14:41:21 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 53479-10 for ; Sun, 21 Jan 2007 14:41:05 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.170]) by postgresql.org (Postfix) with ESMTP id 370559FA66C for ; Sun, 21 Jan 2007 14:41:17 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so819099ugf for ; Sun, 21 Jan 2007 10:41:15 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=VQ/hXv151ebgQvS/zQxFbC6jNaqOwIb8FlGnhwTjP4aJzoLtzYS5UV5TU3RjkFfZQ3qtG+G9Uib4t0kruvv98/eDG61+Bk9dycr0ef16ezQ6zBRAahlMowZv2F5GYiLpCtO8+Aj9B1AgbDutybOU5hFlDBh52YMrijRVkYP0vFo= Received: by 10.66.243.4 with SMTP id q4mr6328864ugh.1169404875343; Sun, 21 Jan 2007 10:41:15 -0800 (PST) Received: by 10.66.217.13 with HTTP; Sun, 21 Jan 2007 10:41:15 -0800 (PST) Message-ID: <55c095e90701211041t40c9bb5br91c94ad1d9b37a7c@mail.gmail.com> Date: Sun, 21 Jan 2007 16:41:15 -0200 From: "Ezequias Rodrigues da Rocha" To: pgsql-sql@postgresql.org Subject: Changing point for commas and commas for point MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_98698_14750824.1169404875308" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/91 X-Sequence-Number: 27243 ------=_Part_98698_14750824.1169404875308 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi list, Here in my country (Brazil) we have the decimal simbol as ' , ' (commas) an= d thousand separator as ' . ' (point) Here my sql uses: to_char(sum(My_column), '99990D00') Is there any way to make this happens ? Regards --=20 =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- A pior das democracias ainda =E9 melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http://ezequiasrocha.blogspot.com/ ------=_Part_98698_14750824.1169404875308 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi list,

Here in my country (Brazil) we have the decimal simbol as &= #39; , ' (commas) and thousand separator as ' . ' (point)
 
Here my sql uses:  to_char(sum(My_column), '= 99990D00')

Is there any way to make this happens ?

Regards

-- =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D
  =             &nb= sp;            =        Atenciosamente (Sincerely)
&nb= sp;            =            Ezequias = Rodrigues da Rocha
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -
A pior das democracias ainda =E9 melhor do que a melhor das ditaduras<= br>The worst of democracies is still better than the better of dictatorship= s
http://ezequiasrocha.blo= gspot.com/ ------=_Part_98698_14750824.1169404875308--