Re: [SQL] Unexplained SQL behavior

2002-08-18 Thread Tom Lane
"JOE" <[EMAIL PROTECTED]> writes: > I am debugging a performance problem with a view. I have narrowed down the= > problem to when I adeed columns to my view. Okay, I see the problem: it is in fact a bug, and one that's been around for awhile. (Curious no one's noticed before.) When you wrote

Re: [SQL] Unexplained SQL behavior

2002-08-17 Thread Tom Lane
"JOE" <[EMAIL PROTECTED]> writes: > In the examples below I have a view with 10 columns. I run an explain plan= > and it uses the primary key of the driver table (enrollment table) as to b= > e expected and executes in 1.86 msec. When I added another columns (and it= > is a null value casted t