Re: [SQL] optimizer woes ?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [SQL] optimizer woes ?
Дата
Msg-id 199906152009.QAA02107@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [SQL] optimizer woes ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
> The TODO entry is insufficiently ambitious: it should read "implement
> a general-purpose constant-subexpression-reduction step".  (Actually,

Changed:
* Convert function(constant) into a constant for index use

> I think that TODO entry might refer to something completely different
> ... wasn't the complaint that you couldn't make an index on
> "date_part('date', field)"? )

This is a separate issue.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] optimizer woes ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] Maybe a bug with SQL processor