[PERFORM] Index on function that returns type with sub fields

2010-12-26 Thread Desmond Coertzen
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 =

[PERFORM] Create index on subfield returned by function that returns base type with sub fields

2010-12-23 Thread Desmond Coertzen
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 =