Postgres Pro
Downloads
Home   >   mailing lists

Thread: select 5/2???

select 5/2???

From
"guard"
Date:
dear all

I run select 5/2  = 2
who to get "2.5"

thanks


--

Re: select 5/2???

From
missive@frontiernet.net (Lee Harr)
Date:
> 
> 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

Re: select 5/2???

From
BELLON Michel
Date:
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

Re: select 5/2???

From
Christopher Sawtell
Date:
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

Re: select 5/2???

From
BELLON Michel
Date:
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

Re: select 5/2???

From
Szabo Zoltan
Date:
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
>>
>>
>>--
>>
>>
>>
>>