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 77637D1B8AD for ; Tue, 26 Aug 2003 20:12:19 -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 72408-08 for ; Tue, 26 Aug 2003 20:11:51 -0300 (ADT) Received: from localhost (unknown [213.254.5.55]) by svr1.postgresql.org (Postfix) with ESMTP id 942B5D1B8C3 for ; Tue, 26 Aug 2003 20:11:47 -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 19rn9C-00033R-00 for ; Wed, 27 Aug 2003 01:22:46 +0200 From: "Alessandro Depetro" To: pgsql-sql@postgresql.org Subject: smallint with postgresql Date: Wed, 27 Aug 2003 01:22:46 +0200 Message-Id: <20030826231944.M69005@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/334 X-Sequence-Number: 14950 hello folks! I havo to migrate some tables from Informix to Postgresql and I I'm in doubt if I can safely use NUMBER (as suggested for monetary computation in PGSQL guide) as a data type for smallint. TIA and gby Alessandro Depetro -- Coop Service Noncello s.c.a r.l. onlus http://www.mamcoop.it/