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
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!,
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
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
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
"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.
