Esay question, about the numeric format

From: "Rafa Comino" <rafacomino(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Esay question, about the numeric format
Date: 2007-02-22 11:20:12
Message-ID: bd8b58a40702220320l73b09f23l4a4c6a0c198b0f49@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2007-02-22 11:27:25 Re: Esay question, about the numeric format
Previous Message CaT 2007-02-22 10:40:03 Re: Checking for string data that makes sense Re: postgresql vs mysql

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2007-02-22 11:27:25 Re: Esay question, about the numeric format
Previous Message Michael Fuhr 2007-02-22 11:03:54 Re: How compare current_setting(..) ?