pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedselect 5/2???
6+ messages / 5 participants
[nested] [flat]
* select 5/2???
@ 2001-10-03 17:04 guard <guard@ficnet.net>
2001-10-04 00:23 ` Re: select 5/2??? Lee Harr <missive@frontiernet.net>
0 siblings, 1 reply; 6+ messages in thread
From: guard @ 2001-10-03 17:04 UTC (permalink / raw)
To: pgsql-sql
dear all
I run select 5/2 = 2
who to get "2.5"
thanks
--
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: select 5/2???
2001-10-03 17:04 select 5/2??? guard <guard@ficnet.net>
@ 2001-10-04 00:23 ` Lee Harr <missive@frontiernet.net>
0 siblings, 0 replies; 6+ messages in thread
From: missive@frontiernet.net @ 2001-10-04 00:23 UTC (permalink / raw)
To: pgsql-sql
>
> I run select 5/2 = 2
> who to get "2.5"
>
integer/integer = integer
float/integer = float
integer/float = float
integer/integer::float = float
test=# SELECT 5.0/2;
?column?
----------
2.5
(1 row)
test=# SELECT 5/2::float;
?column?
----------
2.5
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: select 5/2???
@ 2001-10-08 09:31 BELLON Michel <Michel.Bellon@lcie.fr>
2001-10-08 10:39 ` Re: select 5/2??? Christopher Sawtell <csawtell@paradise.net.nz>
2001-10-08 10:40 ` Re: select 5/2??? Szabo Zoltan <col@mportal.hu>
0 siblings, 2 replies; 6+ messages in thread
From: BELLON Michel @ 2001-10-08 09:31 UTC (permalink / raw)
To: guard <guard@ficnet.net>; 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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: select 5/2???
2001-10-08 09:31 Re: select 5/2??? BELLON Michel <Michel.Bellon@lcie.fr>
@ 2001-10-08 10:39 ` Christopher Sawtell <csawtell@paradise.net.nz>
1 sibling, 0 replies; 6+ messages in thread
From: Christopher Sawtell @ 2001-10-08 10:39 UTC (permalink / raw)
To: BELLON Michel <Michel.Bellon@lcie.fr>; guard <guard@ficnet.net>; pgsql-sql
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: select 5/2???
2001-10-08 09:31 Re: select 5/2??? BELLON Michel <Michel.Bellon@lcie.fr>
@ 2001-10-08 10:40 ` Szabo Zoltan <col@mportal.hu>
1 sibling, 0 replies; 6+ messages in thread
From: Szabo Zoltan @ 2001-10-08 10:40 UTC (permalink / raw)
To: pgsql-sql
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: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
>>
>>
>>--
>>
>>
>>
>>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: select 5/2???
@ 2001-10-08 11:23 BELLON Michel <Michel.Bellon@lcie.fr>
0 siblings, 0 replies; 6+ messages in thread
From: BELLON Michel @ 2001-10-08 11:23 UTC (permalink / raw)
To: csawtell@paradise.net.nz; 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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2001-10-08 11:23 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-10-03 17:04 select 5/2??? guard <guard@ficnet.net>
2001-10-04 00:23 ` Lee Harr <missive@frontiernet.net>
2001-10-08 09:31 Re: select 5/2??? BELLON Michel <Michel.Bellon@lcie.fr>
2001-10-08 10:39 ` Christopher Sawtell <csawtell@paradise.net.nz>
2001-10-08 10:40 ` Szabo Zoltan <col@mportal.hu>
2001-10-08 11:23 Re: select 5/2??? BELLON Michel <Michel.Bellon@lcie.fr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox