[postgis-users] Re: [mapserver-users] can an ogr tileindex refer to a PG table?

Paul Ramsey pramsey at cleverelephant.ca
Wed Feb 27 11:32:42 PST 2008

Are you confirming that still doesn't work? What I make of it is that
the interaction of the SQL parser, the planner and the constraint
exclusion code might not allow your sub-select trick, but you should
seek the advice of experts on the pgsql list.


On 2/27/08, Neil Best <nbest at lanworth.com> wrote:
> Paul Ramsey wrote:
>  > What happens when you remove PostGIS from the equation. This might be
>  > a core PgSQL question.
>  >
>  > EXPLAIN ANALYZE SELECT count(*) FROM mapunits
>  >   WHERE areasymbol IN (SELECT 'IA199' as a)
>  >
> I think you're on to something there, Paul.  Very astute.  What do you
>  make of this?

More information about the postgis-users mailing list