From: Bruno Wolff III <bruno@wolff.to>
To: Rafa Comino <rafacomino@gmail.com>
Cc: pgsql-sql@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Re: Esay question, about the numeric format
Date: Wed, 28 Feb 2007 19:19:52 -0600
Message-ID: <20070301011952.GA5007@wolff.to> (raw)
In-Reply-To: <bd8b58a40702220320l73b09f23l4a4c6a0c198b0f49@mail.gmail.com>
References: <bd8b58a40702220320l73b09f23l4a4c6a0c198b0f49@mail.gmail.com>
On Thu, Feb 22, 2007 at 12:20:12 +0100,
Rafa Comino <rafacomino@gmail.com> wrote:
> Hi every body
> I have this query
> SELECT 20.00::numeric(38,2)
> and postgre gives me 20, i need that postgre gives me 20.00
> What can i do? i suppose this must be easy, but i dont find how to do ir
> thanks every body
If the exact output format matters, you should probably use to_char to convert
the number to a string.
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: bruno@wolff.to, rafacomino@gmail.com, pgsql-general@postgresql.org
Subject: Re: Esay question, about the numeric format
In-Reply-To: <20070301011952.GA5007@wolff.to>
* 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