Re: index on function - Mailing list pgsql-hackers

From Tom Lane
Subject Re: index on function
Date
Msg-id 15657.1053696212@sss.pgh.pa.us
Whole thread Raw
In response to index on function  (You Lun <youlun2000@yahoo.com>)
List pgsql-hackers
You Lun <youlun2000@yahoo.com> writes:
> I want to create a function index like this:
> create index idx on R (f(R))
> But it doesn't pass PostgreSQL's grammar.

Right now you have no alternative but to spell out all the columns of R.

There has been talk of fixing this by replacing functional indexes with
indexes over general expressions, but I dunno how soon it will happen.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Peter Galbavy"
Date:
Subject: Re: $PostgreSQL$ for revision info
Next
From: Tom Lane
Date:
Subject: Re: problem inserting tuples with access methods