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
where (sp_address_text_to_template(address_text)).city_name =
,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?
pgsql-performance by date
|Next:||From: Andres Freund||Date: 2010-12-23 17:03:33|
|Subject: Re: Create index on subfield returned by function that returns base type with sub fields|
|Previous:||From: Jeff Janes||Date: 2010-12-23 16:37:51|
|Subject: Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?|