Which postgres version?
in PostgreSQL 7.1.2 on i686-pc-linux-gnu, compiled by GCC 2.96 :
db=> select -5./2.; ?column?
---------- -2.5
(1 row)
CoL
BELLON Michel wrote:
> 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
>>
>>
>>--
>>
>>
>>
>>