Re: [GENERAL] Esay question, about the numeric format

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

Re: [GENERAL] Esay question, about the numeric format

am Thu, dem 22.02.2007, um 12:20:12 +0100 mailte Rafa Comino folgendes: > 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 Works for me: (version 8.1) test=*# SELECT 20.00::numeric(38,2); numeric - 20.00 (1

[GENERAL] Esay question, about the numeric format

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