OK the problem is with ZEOS Components Michel BELLON LCIE - Informatique appliquée 33 (0)1 40 95 60 35
> -----Message d'origine----- > De: Christopher Sawtell [SMTP:[EMAIL PROTECTED]] > Date: lundi 8 octobre 2001 12:39 > À: BELLON Michel; guard; [EMAIL PROTECTED] > Objet: Re: [SQL] select 5/2??? > > On Mon, 08 Oct 2001 22:31, BELLON Michel wrote: > Works ok for me. > > chris=# select -5/2.0; > ?column? > ---------- > -2.5 > (1 row) > > chris=# select version(); > version > ------------------------------------------------------------- > PostgreSQL 7.1.1 on i586-pc-linux-gnu, compiled by GCC 2.96 > (1 row) > > > 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 5: Have you checked our extensive FAQ? > > > > > > http://www.postgresql.org/users-lounge/docs/faq.html > > > > ---------------------------(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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
