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

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


pgsql-sql by date:

Previous
From: Haller Christoph
Date:
Subject: Re: sql + C
Next
From: Christopher Sawtell
Date:
Subject: Re: select 5/2???