Received: from hermes.lcie.fr ([194.51.30.89]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f98BMGn30576 for ; Mon, 8 Oct 2001 07:22:16 -0400 (EDT) (envelope-from Michel.Bellon@lcie.fr) Received: by HERMES with Internet Mail Service (5.5.2448.0) id <4KCA96AA>; Mon, 8 Oct 2001 13:23:23 +0200 Message-ID: <61D1EAA01DEFD111B5D60008C724E5E9B996C4@HERMES> From: BELLON Michel To: csawtell@paradise.net.nz, pgsql-sql@postgresql.org Subject: Re: select 5/2??? Date: Mon, 8 Oct 2001 13:23:19 +0200 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id f98BMHn30577 X-Archive-Number: 200110/112 X-Sequence-Number: 5067 OK the problem is with ZEOS Components Michel BELLON LCIE - Informatique appliquée 33 (0)1 40 95 60 35 > -----Message d'origine----- > De: Christopher Sawtell [SMTP:csawtell@paradise.net.nz] > Date: lundi 8 octobre 2001 12:39 > À: BELLON Michel; guard; pgsql-sql@postgresql.org > Objet: Re: [SQL] select 5/2??? > > 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