PostgreSQL 7.3.3, GCC 2.96 on Redhat
7.2
Not sure whether you classify this as a bug or
not?
Anyway here goes:
I have a partial index such as:
CREATE UNIQUE INDEX tbl_test_key ON
tbl_test USING btree (s_mnem) WHERE ((n_status
& (~9)) <> 0);
I have a select statement such as:
SELECT s
"Donald Fraser" <[EMAIL PROTECTED]> writes:
> Not sure whether you classify this as a bug or not?
It's a bug --- it's fixed for 7.4. 7.3 has some problems with the
timing of constant simplification in queries vs. predicate expressions.
I'm surprised you can get it to use the index at all, though
