Tasneem,
> For example: For 6,
> the range defined by NEAR is: 4 – 8 For
> 2147,483,647, the range defined by NEAR is: 1717,986,917 –
> 2576,980,377 But yes, for other cases it may not give good results. We can
> give the option for the user to specify the membership degree, or one can
> always use the BETWEEN operator when he knows the thresholds exactly.
Oh, so this is actually based on a direct calculation on the values, rather
than on the population of data. That's much easier; heck, you could index on
it.
--
Josh Berkus
PostgreSQL @ Sun
San Francisco