Re: Huge speed penalty using <>TRUE instead of =FALSE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Huge speed penalty using <>TRUE instead of =FALSE
Дата
Msg-id 2279.1249917002@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Huge speed penalty using <>TRUE instead of =FALSE  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Huge speed penalty using <>TRUE instead of =FALSE
Список pgsql-bugs
Robert Haas <robertmhaas@gmail.com> writes:
> On Fri, Jul 17, 2009 at 10:21 AM, Tom Lane<tgl@sss.pgh.pa.us> wrote:
>> Actually, now that I think about it, the planner already has
>> datatype-specific knowledge about boolean equality (see
>> simplify_boolean_equality).  It would take just a few more lines of code
>> there to recognize "x <> true" and "x <> false" as additional variant
>> spellings of the generic "x" or "NOT x" constructs.  Not sure if it's
>> worth the trouble though; how many people really write such things?

> I don't know, but there's probably somebody.  I probably did it myself
> a few times, when I was just starting out.  If it's easy, it seems
> worth doing.

http://archives.postgresql.org/pgsql-committers/2009-07/msg00164.php

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: wader2
Дата:
Сообщение: Re: BUG #4961: pg_standby.exe crashes with no args
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #4972: RFE: convert timestamps to fractional seconds