Using Postgres 9.6
I am trying to create an index on a type adt_flds with a field also named
create type adt_flds as ( created_at timestamp , updated_at timestamp , created_by text , updated_by text , created_by_client_addr inet , updated_by_client_addr inet , created_by_client_cmptr text , updated_by_client_cmptr text );
My attempt is as follows for
schema = document
table = training_complete_history
field = adt_flds
field column = created_at
create index training_complete_history_adt_flds_index on document.training_complete_history ((adt_flds).created_at);
Unfortunately, my attempt yields the following error.
 ERROR: syntax error at or near ")" Position: 114.
How would I properly index