Index on function that returns type with sub fields - Mailing list pgsql-performance

From Desmond Coertzen
Subject Index on function that returns type with sub fields
Date
Msg-id AANLkTin-4EsDC5D9eF58-QFcUx=sh_c1W---e_-bWxG8@mail.gmail.com
Whole thread Raw
List pgsql-performance
Hello,

Is is possible to create an index on a field on a function that returns a data type that contains subfields?

It is possible to do this:
create index indx_test
on address
(sp_address_text_to_template(address_text))
where (sp_address_text_to_template(address_text)).city_name = 'some_city_on_some_planet';

,but I would like to create the index without the partial clause to index results only from sp_address_text_to_template(address_text)).city_name.

Is this possible? How would I write the statement?

Thanks,

Desmond.

pgsql-performance by date:

Previous
From: Marti Raudsepp
Date:
Subject: Re: encourging bitmap AND
Next
From: Jeff Janes
Date:
Subject: Re: concurrent IO in postgres?