Received: from snigglefritz.expressus.com (dhcphost11.expressus.com [64.114.34.80]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBSM0eL35020 for ; Thu, 28 Dec 2000 17:00:40 -0500 (EST) (envelope-from jkakar@expressus.com) Received: (from jkakar@localhost) by snigglefritz.expressus.com (8.11.1/8.11.1/Debian 8.11.0-6) id eBSM0lJ13297 for pgsql-sql@postgresql.org; Thu, 28 Dec 2000 14:00:47 -0800 From: jkakar@expressus.com Date: Thu, 28 Dec 2000 14:00:46 -0800 To: pgsql-sql@postgresql.org Subject: How to trim values? Message-ID: <20001228140046.A13292@expressus.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.12i X-Archive-Number: 200012/283 X-Sequence-Number: 620 Hi, I'm trying to figure out how to take a value like 3.68009074974387 (that is calculated from values in my database) and have PostgreSQL hand me 3.68. Any suggestions would be appreciated. Thanks, Jamu. -- Jamu Kakar (Developer) Expressus Design Studio, Inc. jkakar@expressus.com 708-1641 Lonsdale Avenue V: (604) 903-6999 North Vancouver, BC, V7M 2J5