attached is the WIP patch for cross-column statistics and
extra expression statistics.
My question is that why pg_node_tree is unusable as
syscache attribute? I attempted to alias it as text in the patch
but I get the following error if I try to use it by setting
USE_SYSCACHE_FOR_SEARCH to 1 in selfuncs.c.
Directly using the underlying pg_statistic3 doesn't cause an error.
zozo=# select * from t1 where i+1 = 5;
ERROR: could not determine which collation to use for string comparison
HINT: Use the COLLATE clause to set the collation explicitly.
The table looks like this:
create table t1 (id serial primary key, t text, i integer);
Cybertec Schönig & Schönig GmbH
A-2700 Wiener Neustadt, Austria
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2011-04-28 14:04:26|
|Subject: Re: Extension Packaging |
|Previous:||From: Andrew Dunstan||Date: 2011-04-28 14:03:36|
|Subject: Re: unknown conversion %m|