"Rafael Villalobos Prats" <[EMAIL PROTECTED]> writes:
> Why is different: 'SELECT (x)::FLOAT8' than 'SELECT x::FLOAT8'
The :: operator binds more tightly than most other operators. As Iain
replied, most of your divisions are going to be integer divisions that
discard the fractional part.
Ok, that's right.
Many thanks
Rafa-.
-Mensaje original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] En nombre de Fothergill, Iain
Enviado el: miércoles, 18 de febrero de 2004 16:31
Para: [EMAIL PROTECTED]
Asunto: Re: [BUGS] Select (str)::FLOAT8 BUG
My guess would be...
1000/50
My guess would be...
1000/5000/7::FLOAT8 is really 1000::INT/500::INT/7::FLOAT8 (int may be some other
integer type) whereas (1000/500/7)::FLOAT8 is (1000::INT/500::INT/7::INT)::FLOAT8 i.e.
the resultan integer is casted to type FLOAT8 after the maths has been done on
integers. Thats what I'd
Hi!,
I think i have found a bug.
I´ve tried it in PgSQL 7.3.5 & 7.4.1
When I do:
atisae_oct_1=# SELECT (1000/500/7)::FLOAT8 as v_numero;
v_numero
--
0
(1 row)
atisae_oct_1=# SELECT 1000/500/7::FLOAT8 as v_numero;
v_numero
---
0.285714285714286
(1 row)
at
On Wednesday 18 February 2004 05:54, hessam wrote:
> Dear Richard,
>
> Thank you for your reply.Below are results of ps and top commands on
> my new linux Box:
>
> There are 64 database connection made by freeradius.When I reboot my
> machine with 'chkconfig postgresql off' 'chkconfig radiusd off'
Hi all,
Is it possible to improve "configure" script of
postgresql to allow to specify in which directory a
3rd tool is installed ?
An option like --with-zlib=[DIR] is very usefull
because w/ the current (7.4.1) configure script, you
have to set by yourself some variables to specify
where is inst
