Avoid querying the_geom field in Postgis - how?
Stephen Woodbridge
woodbri at SWOODBRIDGE.COM
Tue Feb 21 05:17:02 PST 2006
One way would be to put the_geom in a separate table and link it to the
table with the attributes with a unique id column.
-Steve W
Stefan Schwarzer wrote:
> Hi,
>
> does anyone know how to build a query that SELECTs all fields but not
> the_geom? I have a couple of tables, holding statistical information as
> well as the geospatial one. When I query the table I'd like to query
> only the statistical part - not the geospatial, which is not necessary
> and slows done incredibly the query. I searched a bit within the
> Postgres SQL domain. It seems there is an EXCEPT statement, but it
> seems that it works differently...
>
> Thanks for any help,
>
> Stef
>
More information about the MapServer-users
mailing list