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

 · 

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