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.
Vadim