Re: [HACKERS] indexes and floats
От | Bruce Momjian |
---|---|
Тема | Re: [HACKERS] indexes and floats |
Дата | |
Msg-id | 199808061541.LAA07831@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: [HACKERS] indexes and floats (Vadim Mikheev <vadim@krs.ru>) |
Ответы |
Re: [HACKERS] indexes and floats
|
Список | pgsql-hackers |
> Thomas G. Lockhart wrote: > > > > > istm that we should be focusing on Vadim's hints on what it would take > > > to use indices with function calls on constants... > > > > Looking at Vadim's note again, maybe it will be the parser's duty to > > insert the PARAM_EXEC node; will need more details or some time to look > > at it... > > Sorry, but maybe it would be better to add new attribute > to pg_proc (and change CREATE FUNCTION syntax) to let > parser know does result of function call on constants depend > on execution time or not. This would be much better just > execute function in parser and replace function with > constant. > Currently, only random(), now() and SPI-functions should be > replaced by PARAM_EXEC, all others could be evaluated by parser. I see. We have pg_proc.proiscachable. This looks like a good candidate, and is not used for anything currently. Maybe rename it to something clearer. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h)
В списке pgsql-hackers по дате отправления: