Received: from deborah.paradise.net.nz (deborah.paradise.net.nz [203.96.152.32]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f98AfMn23563 for ; Mon, 8 Oct 2001 06:41:23 -0400 (EDT) (envelope-from csawtell@paradise.net.nz) Received: from berty.localnet (202-0-37-152.cable.paradise.net.nz [202.0.37.152]) by deborah.paradise.net.nz (Postfix) with SMTP id 31D1FD1A60; Mon, 8 Oct 2001 23:41:19 +1300 (NZDT) Content-Type: text/plain; charset="iso-8859-1" From: Christopher Sawtell Reply-To: csawtell@paradise.net.nz To: BELLON Michel , guard , pgsql-sql@postgresql.org Subject: Re: select 5/2??? Date: Mon, 8 Oct 2001 23:39:17 +1300 X-Mailer: KMail [version 1.2] References: <61D1EAA01DEFD111B5D60008C724E5E9B995AB@HERMES> In-Reply-To: <61D1EAA01DEFD111B5D60008C724E5E9B995AB@HERMES> MIME-Version: 1.0 Message-Id: <01100823391700.29316@berty.localnet> Content-Transfer-Encoding: 8bit X-Archive-Number: 200110/111 X-Sequence-Number: 5066 On Mon, 08 Oct 2001 22:31, BELLON Michel wrote: Works ok for me. chris=# select -5/2.0; ?column? ---------- -2.5 (1 row) chris=# select version(); version ------------------------------------------------------------- PostgreSQL 7.1.1 on i586-pc-linux-gnu, compiled by GCC 2.96 (1 row) > 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 > > > > > > -- > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 5: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/users-lounge/docs/faq.html > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly