Re: select 5/2??? - Mailing list pgsql-sql

From BELLON Michel
Subject Re: select 5/2???
Date
Msg-id 61D1EAA01DEFD111B5D60008C724E5E9B996C4@HERMES
Whole thread Raw
In response to select 5/2???  ("guard" <guard@ficnet.net>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Christopher Sawtell
Date:
Subject: Re: select 5/2???
Next
From: Tomasz Myrta
Date:
Subject: Re: temporary views