[postgis-users] finalize PostgreSQL 7.3 support

David Blasby dblasby at refractions.net
Fri Nov 22 09:49:53 PST 2002


Carl,

You've been looking under the covers!

Postgresql does do auto-magical type transforms!

Under the covers, when you do a:

<geometry> && <box3d>

postgresql looks for a  <geometry> && <box3d> function.   It will not find one.
Next, it looks for a way to convert the types to a function it does know.  It
finds a conversion function for <box3d> to <geometry>, and runs it.  It then
calls the <geometry> && <geometry> function.  This operator is indexed, so it
will use the GiST index.

The (islossy) flag for GiST indexes is currently ignored by postgresql, so dont
worry about not having to specify it.  They probably removed it so it wasnt
confusing.

What did you have to change in the postgis.sql file to make it compatible with
7.3?

dave






More information about the postgis-users mailing list