Joe Van Dyk wrote: > My assumption was that WITH acted just like subselects, but apparently they don't? Using WITH doesn't > use the expected index. Currently WITH acts as an "optimization fence", that means that means that the planner won't move conditions into or out of the WITH query. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
