You Lun <youlun2000(at)yahoo(dot)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