Quick Links

chop off non-meaningful digits

From:	"SunWuKung" <Balazs(dot)Klein(at)t-online(dot)hu>
To:	pgsql-general(at)postgresql(dot)org
Subject:	chop off non-meaningful digits
Date:	2006-11-13 13:45:44
Message-ID:	1163425544.031647.208480@m7g2000cwm.googlegroups.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

What would be the easiest way to get back only the meaningful digits of
a numeric value in a pgsql function? eg?

1.002 --> 1.002
1.020 --> 1.02
1.200 --> 1.2
1.000 --> 1

Thanks
SWK

Responses

Re: chop off non-meaningful digits at 2006-11-13 13:51:06 from Raymond O'Donnell
Re: chop off non-meaningful digits at 2006-11-13 13:53:00 from Shoaib Mir
Re: chop off non-meaningful digits at 2006-11-13 13:58:15 from A. Kretschmer

Browse pgsql-general by date

	From	Date	Subject
Next Message	Walter Vaughan	2006-11-13 13:45:58	Re: Trying to Install PhP-4 Module for PostgreSQL from
Previous Message	Shoaib Mir	2006-11-13 13:40:07	Re: SQL - update table problem...