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:[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 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