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.
P. On 2/27/08, Neil Best <[EMAIL PROTECTED]> 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? > > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
