Re: select 5/2???
От | BELLON Michel |
---|---|
Тема | Re: select 5/2??? |
Дата | |
Msg-id | 61D1EAA01DEFD111B5D60008C724E5E9B996C4@HERMES обсуждение исходный текст |
Ответ на | select 5/2??? ("guard" <guard@ficnet.net>) |
Список | pgsql-sql |
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:csawtell@paradise.net.nz] > Date: lundi 8 octobre 2001 12:39 > À: BELLON Michel; guard; pgsql-sql@postgresql.org > 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: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 > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly
В списке pgsql-sql по дате отправления: