Simon Riggs [EMAIL PROTECTED] writes:
In a thread in July last year, I raised the possibility of transforming
a query to allow functional indexes to be utilised automatically.
http://archives.postgresql.org/pgsql-hackers/2006-07/msg00323.php
This idea can work and has many benefits, but
Gregory Stark [EMAIL PROTECTED] writes:
I've thought further about this and I believe the problem is simpler than we
were thinking previously. All we need is one boolean flag on the equality
operator for the data type (or perhaps it would be more convenient to have it
on the operator class)
On Thu, 2007-01-25 at 16:20 -0500, Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
A simpler, alternate proposal is to allow the user to specify whether a
functional index is transformable or not using CREATE or ALTER INDEX,
with a default of not transformable. That then leaves the
Simon Riggs [EMAIL PROTECTED] writes:
If there's clear benefit and a clear way forward, then we might just be
OK for 8.3. If not, I'll put this back on the shelf again in favour of
other ideas.
I think this is still a long way off, and there are probably more useful
things to work on for 8.3.
On Fri, 2007-01-26 at 10:58 -0500, Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
If there's clear benefit and a clear way forward, then we might just be
OK for 8.3. If not, I'll put this back on the shelf again in favour of
other ideas.
I think this is still a long way off, and
In a thread in July last year, I raised the possibility of transforming
a query to allow functional indexes to be utilised automatically.
http://archives.postgresql.org/pgsql-hackers/2006-07/msg00323.php
This idea can work and has many benefits, but there are some
complexities. I want to
Simon Riggs [EMAIL PROTECTED] writes:
A simpler, alternate proposal is to allow the user to specify whether a
functional index is transformable or not using CREATE or ALTER INDEX,
with a default of not transformable. That then leaves the responsibility
for specifying this with the user, who as