"Rafael Villalobos Prats" <rvillalobos(at)asapci(dot)es> writes:
> Why is different: 'SELECT (xxxxx)::FLOAT8' than 'SELECT xxxxx::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. You can either add casts or add ".0" to
your numbers to cause them to be considered non-integers.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Alexander Troppmann||Date: 2004-02-19 18:16:42|
|Subject: Maybe a bug found with nextval() function|
|Previous:||From: Tom Lane||Date: 2004-02-18 16:05:41|
|Subject: Re: zlib directory in configure. |