| From: | BELLON Michel <Michel(dot)Bellon(at)lcie(dot)fr> |
|---|---|
| To: | guard <guard(at)ficnet(dot)net>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: select 5/2??? |
| Date: | 2001-10-08 09:31:21 |
| Message-ID: | 61D1EAA01DEFD111B5D60008C724E5E9B995AB@HERMES |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Sawtell | 2001-10-08 10:39:17 | Re: select 5/2??? |
| Previous Message | Bhuvan A | 2001-10-08 08:46:47 | How to Return Unique Elements From An Array? |