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:[EMAIL PROTECTED]]
> > Date: mercredi 3 octobre 2001 19:05
> > À: [EMAIL PROTECTED]
> > 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 [EMAIL PROTECTED] so that your
> message can get through to the mailing list cleanly
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
