X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 29747476419 for ; Fri, 2 May 2003 17:38:21 -0400 (EDT) Received: from hotmail.com (f72.law12.hotmail.com [64.4.19.72]) by postgresql.org (Postfix) with ESMTP id C299247638D for ; Fri, 2 May 2003 17:38:19 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 2 May 2003 14:38:21 -0700 Received: from 207.34.65.240 by lw12fd.law12.hotmail.msn.com with HTTP; Fri, 02 May 2003 21:38:21 GMT X-Originating-IP: [207.34.65.240] X-Originating-Email: [daniel_katka@hotmail.com] From: "Katka a Daniel Dunajsky" To: pgsql-sql@postgresql.org Subject: How to increase precision? Date: Fri, 02 May 2003 15:38:21 -0600 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 02 May 2003 21:38:21.0638 (UTC) FILETIME=[27259E60:01C310F3] X-Spam-Status: No, hits=-1.6 required=5.0 tests=BAYES_30 version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/33 X-Sequence-Number: 13198 Hello all, this is a newbie question: How to increase the precision of calculations in posgresql? When I run this query: select 5/2; I get: ?column? -------- 2 It should be 2.5 shouldn't it? Thank you for your time. Daniel _________________________________________________________________ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail