"Mark Cave-Ayland" <[EMAIL PROTECTED]> writes: > ... But in the case of <column> <op> > <unknown constant>, if we're estimating the number of rows to return then > that becomes harder
I didn't say it was easy ;-). The existing selectivity functions can't do better than a rough guess in such cases, and I don't expect you can either. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly