Postgres Pro
Downloads
Home   >   mailing lists

Re: Esay question, about the numeric format - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Esay question, about the numeric format
Date
Msg-id 20070301011952.GA5007@wolff.to
Whole thread Raw
In response to Esay question, about the numeric format  ("Rafa Comino" <rafacomino@gmail.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Naz Gassiep
Date:
Subject: Re: Select retrieval slowdown after db drop/reload. Suggestions?
Next
From: Shaun Johnston
Date:
Subject: Assistance with Query Optimisation?