[GENERAL] Format Float numbers

Hi, I want format a column in select result: 1.1 = 1.10 Any idea? Thanks! Fernando Abraços, Fernando Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento! http://br.mail.yahoo.com/ ---(end of broadcast)---

Re: [GENERAL] Format Float numbers

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

Re: [GENERAL] Format Float numbers

I want format a column in select result: 1.1 = 1.10 Any idea? Try the to_date() function like SELECT to_char(1.1, '0.99'); Yours, Laurenz Albe ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate