Re: To all the pgsql developers..Have a look at the operators proposed by me in my researc - Mailing list pgsql-hackers

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