On Thu, 4 May 2000, Tom Lane wrote:
> > EXPLAIN
> > SELECT *
> > FROM part p -- let p alias to part
> > WHERE part.part_id = 42; -- but don't use p
>
> > Nested Loop (cost=0.00..2429.30 rows=50735 width=219)
> > -> Index Scan using part_pkey on part (cost=0.00..3.60 rows=1 width=4)
> > -> Seq Scan on part p (cost=0.00..1918.35 rows=50735 width=215)
>
> This is correct behavior.
Isn't it time we disable this by default or at least provide an option for
it? It seems this comes up every week.
--
Peter Eisentraut Sernanders väg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden