On Thu, Feb 22, 2007 at 12:20:12 +0100, Rafa Comino <rafacomino@xxxxxxxxx> 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.
