"Craig Harris" <harris@xxxxxxxxxxxxxx> writes: > does any one know why the SEQSCAN node has TWO TARGETENTRYs? It doesn't stop to notice that the Var is not referenced by any upper nodes in this particular scenario. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general