Received: from hermes.lcie.fr ([194.51.30.89]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f989UKn07918 for ; Mon, 8 Oct 2001 05:30:21 -0400 (EDT) (envelope-from Michel.Bellon@lcie.fr) Received: by HERMES with Internet Mail Service (5.5.2448.0) id <4KCA955L>; Mon, 8 Oct 2001 11:31:27 +0200 Message-ID: <61D1EAA01DEFD111B5D60008C724E5E9B995AB@HERMES> From: BELLON Michel To: guard , pgsql-sql@postgresql.org Subject: Re: select 5/2??? Date: Mon, 8 Oct 2001 11:31:21 +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 f989ULn07919 X-Archive-Number: 200110/110 X-Sequence-Number: 5065 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