Re: select 5/2???

From: Szabo Zoltan <col(at)mportal(dot)hu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: select 5/2???
Date: 2001-10-08 10:40:55
Message-ID: 3BC182B7.3040009@mportal.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(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
>>
>>
>>--
>>
>>
>>
>>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Haller Christoph 2001-10-08 11:12:16 Re: sql + C
Previous Message Christopher Sawtell 2001-10-08 10:39:17 Re: select 5/2???