X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 90238535E2 for ; Sun, 24 Apr 2005 06:15:33 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17029-02 for ; Sun, 24 Apr 2005 09:15:26 +0000 (GMT) Received: from hotmail.com (bay12-dav10.bay12.hotmail.com [64.4.35.184]) by svr1.postgresql.org (Postfix) with ESMTP id 259EF535D6 for ; Sun, 24 Apr 2005 06:15:25 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Sun, 24 Apr 2005 02:15:27 -0700 Message-ID: Received: from 210.245.52.109 by BAY12-DAV10.phx.gbl with DAV; Sun, 24 Apr 2005 09:15:27 +0000 X-Originating-IP: [210.245.52.109] X-Originating-Email: [atuan_h@hotmail.com] X-Sender: atuan_h@hotmail.com From: "tuan" To: Subject: Division in Postgre Date: Sun, 24 Apr 2005 16:18:36 +0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-OriginalArrivalTime: 24 Apr 2005 09:15:27.0524 (UTC) FILETIME=[2790D640:01C548AE] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=4.787 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, FORGED_MUA_OUTLOOK, MSGID_FROM_MTA_HEADER X-Spam-Level: **** X-Archive-Number: 200504/398 X-Sequence-Number: 21291 In sql server my division select cast(3 as float)/10 is 0.29999999999. But in postgres select cast(3 as float8)/10 is 0.3. How to get result like sql server? Thank you. Sorry for my english