am Thu, dem 10.01.2008, um 10:03:05 -0300 mailte Fernando Xavier folgendes: > Hi, > > I want format a column in select result: > > 1.1 => 1.10 > > Any idea? Yes. You can use to_char() or a CAST like test=*# select 1.1::numeric(10,2); numeric --------- 1.10 (1 row) 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 majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly