X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 4034FD1B8A5 for ; Tue, 26 Aug 2003 20:20:57 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 80217-01 for ; Tue, 26 Aug 2003 20:20:29 -0300 (ADT) Received: from localhost (unknown [213.254.5.55]) by svr1.postgresql.org (Postfix) with ESMTP id 2CE04D1B8AA for ; Tue, 26 Aug 2003 20:20:26 -0300 (ADT) Received: from localhost ([127.0.0.1] helo=www.mamcoop.it ident=alex) by localhost with esmtp (Exim 3.35 #1 (Debian)) id 19rnHX-00034Z-00 for ; Wed, 27 Aug 2003 01:31:23 +0200 From: "Alessandro Depetro" To: pgsql-sql@postgresql.org Subject: smallfloat with postgresql Date: Wed, 27 Aug 2003 01:31:23 +0200 Message-Id: <20030826232609.M33535@mamcoop.it> X-Mailer: Open WebMail 1.90 20030211 X-OriginatingIP: 80.180.108.69 (alex) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-15 X-MailScanner: Found to be clean X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/332 X-Sequence-Number: 14948 sorry again (I am not smoking crack, only drinking some good ceres...) smallint is not right (it is right for postgresql as a data type as read from the guide)... The real data type is "smallfloat" (found in my informix tables) so, Can I safely use NUMERIC as a data type for monetary computation instead of smallfloat ??? alessandro depetro -- Coop Service Noncello s.c.a r.l. onlus http://www.mamcoop.it/