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 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
[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
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 row) test=*# SELECT 20.00::numeric(38,20); numeric - 20. (1 row) Btw.: http://stoned.homeunix.org/~itsme/postgre/ Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: - Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly