"Merlin Moncure" <mmoncure(at)gmail(dot)com> writes:
> Here is another use-case solved by the patch. Previously, there was
> no easy way to index on a composite function result. The following
> works in HEAD:
> create function func(f foo, a out int, b out int) returns record ...
> create index foo_idx on foo(func(foo));
Urk ... "works" for small values of "work", perhaps. Did you try using
the index from a fresh session?
We could support this for named composite types but not for anonymous
record types. I'm not quite sure how to enforce that distinction
considering that the opclass is defined to take "record". Maybe we
should apply CheckAttributeType() to index column types?
regards, tom lane