On Thu, Feb 22, 2007 at 12:20:12 +0100, Rafa Comino <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
