to_char(0,'FM990D99') = "0." instead of "0"

From: Janning Vygen <vygen(at)gmx(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: to_char(0,'FM990D99') = "0." instead of "0"
Date: 2002-07-22 13:39:43
Message-ID: 200207221339.g6MDdhM27369@janning.planwerk6.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

select to_char(1, 'FM990D99');
1
select to_char(0, 'FM990D99');
0.

how to avoid the decimal point in the second query??

kind regards,
janning

Responses

Browse pgsql-general by date

  From Date Subject
Next Message wsheldah 2002-07-22 13:54:00 Re: Cross-Tab queries in postgres?
Previous Message Cserna Zsolt 2002-07-22 13:33:54 Re: sequence scan, but indexed tables