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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
