Hello!
If a view which calls a function is LEFT JOINed to a table but not all
result rows are matched by some criteria, then the function is called
for each row of the view nevertheless.
It is interesting, that the same query without using a view calls the
function only for those rows wich are r
Hi
My version of postgresql is:
PostgreSQL 8.0.4 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3
20051201 (prerelease) (Debian 4.0.2-5)
I don't cat get real value of int64 fields. spi_get_binval return wrong
values. But it works with int32.
best regards
---(end
I'm experience some strange behaviour when casting numeric values.
Given the following SQL-Statement:
SELECT
a_int,
a_num,
CAST (a_num AS NUMERIC(9,1)) AS CastTo9_1,
CAST (a_num AS NUMERIC(9,2)) AS CastTo9_2,
CAST (a_num AS NUMERIC(9,3)) AS CastTo9_3
FROM f_numtest();
Generated output is:
a_int
Hello Postgres team,
I used wanted to point out the the ( -q, --quiet ) parameter for
reindexdb command utility does not work.
Also reindexdb writes NOTICE to standard err for every table it
reindexes which makes it really hard to use in script as it always
produces an "errror". :-)
If t
Germán Aracil Boned wrote:
> My version of postgresql is:
> PostgreSQL 8.0.4 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3
> 20051201 (prerelease) (Debian 4.0.2-5)
You should update to 8.0.8 ...
> I don't cat get real value of int64 fields. spi_get_binval return wrong
> values. But it w
Andreas Heiduk <[EMAIL PROTECTED]> writes:
> If a view which calls a function is LEFT JOINed to a table but not all
> result rows are matched by some criteria, then the function is called
> for each row of the view nevertheless.
> Note that this seems to happen only for left joins, not for a inne
Sven Welte <[EMAIL PROTECTED]> writes:
> I'm experience some strange behaviour when casting numeric values.
This doesn't really have anything to do with casting as such. The
system thinks it can throw away the cast to NUMERIC(9,2) because the
function result is declared as already NUMERIC(9,2) ..
> I used wanted to point out the the ( -q, --quiet ) parameter for
> reindexdb command utility does not work.
Actually it is *not* a bug. The NOTICE is printed by the REINDEX
command; reindexdb is just a wrapper around REINDEX command. If you
set up 'client_min_messages' in postgresql.conf, you d
