Re: select 5/2???

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(at)paradise(dot)net(dot)nz]
> Date: lundi 8 octobre 2001 12:39
> À: BELLON Michel; guard; pgsql-sql(at)postgresql(dot)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(at)ficnet(dot)net]
> > > Date: mercredi 3 octobre 2001 19:05
> > > À: pgsql-sql(at)postgresql(dot)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(at)postgresql(dot)org so that your
> > message can get through to the mailing list cleanly