pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feed From: BELLON Michel <Michel.Bellon@lcie.fr>
To: csawtell@paradise.net.nz
To: pgsql-sql@postgresql.org
Subject: Re: select 5/2???
Date: Mon, 8 Oct 2001 13:23:19 +0200
Message-ID: <61D1EAA01DEFD111B5D60008C724E5E9B996C4@HERMES> (raw )
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
view thread (6+ messages)
Message-ID: <61D1EAA01DEFD111B5D60008C724E5E9B996C4@HERMES>
Permalink: ../61D1EAA01DEFD111B5D60008C724E5E9B996C4@HERMES/
Also on: postgresql.org/message-id/61D1EAA01DEFD111B5D60008C724E5E9B996C4@HERMES
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Michel.Bellon@lcie.fr, csawtell@paradise.net.nz
Subject: Re: select 5/2???
In-Reply-To: <61D1EAA01DEFD111B5D60008C724E5E9B996C4@HERMES>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox