Re: Oddity with view (now with test case)

От: Tom Lane
Тема: Re: Oddity with view (now with test case)
Дата: ,
Msg-id: 10664.1226430946@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: Oddity with view (now with test case)  (Jim 'Decibel!' Nasby)
Ответы: Re: Oddity with view (now with test case)  (Jim 'Decibel!' Nasby)
Список: pgsql-performance

Скрыть дерево обсуждения

Oddity with view  (Jim 'Decibel!' Nasby, )
 Re: Oddity with view  (Tom Lane, )
  Re: Oddity with view  (Jim 'Decibel!' Nasby, )
   Re: Oddity with view  (Richard Huxton, )
    Re: Oddity with view (now with test case)  (Jim 'Decibel!' Nasby, )
     Re: Oddity with view (now with test case)  (Tom Lane, )
      Re: Oddity with view (now with test case)  (Jim 'Decibel!' Nasby, )
       Re: Oddity with view (now with test case)  (Tom Lane, )
        Re: Oddity with view (now with test case)  (Jim 'Decibel!' Nasby, )
         Re: Oddity with view (now with test case)  (Tom Lane, )
          Re: Oddity with view (now with test case)  (Jim 'Decibel!' Nasby, )
           Re: Oddity with view (now with test case)  (Tom Lane, )
   Re: Oddity with view  (Tom Lane, )

"Jim 'Decibel!' Nasby" <> writes:
> On Nov 10, 2008, at 9:20 PM, Tom Lane wrote:
>> 8.3 gets it right though.

> Doesn't seem to for me... :/

Oh, I was looking at "select * from v2" not "select count(*) from v2".
HEAD is a bit smarter about the latter than 8.3 is.

            regards, tom lane


В списке pgsql-performance по дате сообщения:

От: "Scott Marlowe"
Дата:
Сообщение: Re: Using index for IS NULL query
От: Tom Lane
Дата:
Сообщение: Re: Oddity with view (now with test case)