Re: [BUGS] inet/cidr indexes almost not used

2003-01-19 Thread Gleb Kouzmenko
Bruce, I did SET enable_seqscan to off before EXPLAINs, of course. Optimizer ignored this SET, and I cannot compare seq scan with index one. I quoted two EXPLAINs below again: WHERE i<<'IP' and WHERE 'IP'>>i is logically equivalent, but are planned differently (BTW I thought that inet/cidr ops

Re: [BUGS] inet/cidr indexes almost not used

2003-01-19 Thread Tom Lane
Gleb Kouzmenko <[EMAIL PROTECTED]> writes: > I quoted two EXPLAINs below again: WHERE i<<'IP' and WHERE 'IP'>>i is > logically equivalent, but are planned differently If you'd like to fix that, see match_special_index_operator() and expand_indexqual_conditions() in src/backend/optimizer/path/indxp

[BUGS] Bug #877: numbers are no longer recognized as smallints

2003-01-19 Thread pgsql-bugs
Denis N. Stepanov ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description numbers are no longer recognized as smallints Long Description I have bunch of functions (doesn't matter of which language) which take parameters as 'smallint's.