Re: [HACKERS] indexes and floats

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] indexes and floats
Date: 1998-08-06 06:32:44
Message-ID: 35C94E0C.42BFE455@krs.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Vadim

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Zeugswetter 1998-08-06 08:45:41 AW: [HACKERS] Large objects names
Previous Message Thomas G. Lockhart 1998-08-06 06:17:18 Re: [HACKERS] Declare Cursor question again