Home > mailing lists

to_char(0,'FM990D99') = "0." instead of "0" - Mailing list pgsql-general

From	Janning Vygen
Subject	to_char(0,'FM990D99') = "0." instead of "0"
Date	July 22, 2002 12:43:06
Msg-id	200207221339.g6MDdhM27369@janning.planwerk6.local Whole thread Raw
Responses	Re: to_char(0,'FM990D99') = "0." instead of "0"
List	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

From: Jon Lapham
Date: 22 July 2002, 11:39:28
Subject: viewing/altering the "ON DELETE CASCADE" constraint

From: Chris
Date: 22 July 2002, 12:43:19
Subject: CASE Tools