Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f98B4mn27369 for ; Mon, 8 Oct 2001 07:04:48 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f98AaA927489 for pgsql-sql@postgresql.org; Mon, 8 Oct 2001 06:36:10 -0400 (EDT) (envelope-from news) From: Szabo Zoltan X-Newsgroups: comp.databases.postgresql.sql Subject: Re: select 5/2??? Date: Mon, 08 Oct 2001 12:40:55 +0200 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 53 Message-ID: <3BC182B7.3040009@mportal.hu> References: <61D1EAA01DEFD111B5D60008C724E5E9B995AB@HERMES> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Complaints-To: scrappy@hub.org User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:0.9.4) Gecko/20010913 X-Accept-Language: en-us To: pgsql-sql@postgresql.org X-Archive-Number: 200110/154 X-Sequence-Number: 5109 Which postgres version? in PostgreSQL 7.1.2 on i686-pc-linux-gnu, compiled by GCC 2.96 : db=> select -5./2.; ?column? ---------- -2.5 (1 row) CoL BELLON Michel wrote: > The good select is > > SELECT 5./2. > > BUT !!!! > > select -5./2. > +----------+ > | ?column? | > +----------+ > | 2.5 | not -2.5 > +----------+ > > !!!! > > Michel BELLON > LCIE - Informatique appliquée > 33 (0)1 40 95 60 35 > > >>-----Message d'origine----- >>De: guard [SMTP:guard@ficnet.net] >>Date: mercredi 3 octobre 2001 19:05 >>À: pgsql-sql@postgresql.org >>Objet: select 5/2??? >> >>dear all >> >>I run select 5/2 = 2 >>who to get "2.5" >> >>thanks >> >> >>-- >> >> >> >>