Pierre's response is probably the correct one. You need the WHERE clause as the ST_Value is being run upon every tile in that table.
-bborie On 06/29/2012 02:38 PM, Robin Wilson wrote: > Hi bborie, > > Thanks for the idea. I've set up the logging and checked and only one query > is being sent by the client. I've also checked the code used by the client, > which simply runs one query and gets the results. > > Does anyone have any idea why this may be happening? > > Cheers, > > Robin > > ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ > > Robin, > > I can't say for certain but it looks like your client (not psql) is > sending off multiple queries. The nulls would return if the point being > sampled isn't in any of the tiles. > > You could enable statement logging (log_statement) in PostgreSQL to see > what statements are being run from your connector. > > http://www.postgresql.org/docs/9.0/interactive/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT > > -bborie > > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
