Re: extra TARGETENTRY when group by function( col )?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Craig Harris" <harris(at)SummerEyes(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: extra TARGETENTRY when group by function( col )?
Date: 2010-12-22 17:00:25
Message-ID: 6957.1293037225@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Craig Harris" <harris(at)SummerEyes(dot)com> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-12-22 17:03:30 Re: could not open relation...No such file or directory
Previous Message Adam Bruss 2010-12-22 16:47:37 Error when using phpPgAdmin