Re: 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