On 3/17/06, Bruno Wolff III <[EMAIL PROTECTED]> wrote: > Have you looked at using the Earth Distance contrib module? If a spherical > model of the earth is suitable for your application, then it may work for you > and might be easier than trying to create Gist indexes yourself.
earth distance = great stuff. If the maximum error is known then you can just pad the distance and filter the result on the client if exact precision is needed. Merlin ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match