How to implement the creation of a complex index into sopm-file?

[edi]

Hello,

I wrote a module TicketExtraData
For this module I ctreated a ticket_extra_data table with an extra_data field of type JSONB
Now I want to implement the creation of an index for this field in a sopm-file.
create index ticket_extra_data_gin ON "ticket_extra_data" USING GIN ( to_tsvector('russian', extra_data->>'address'));

To do this, I added a subsection to the <TableCreate Name = "ticket_extra_data"> section like this
<Index Name="ticket_extra_data_gin">
<IndexColumn Name="extra_data" Using="USING GIN ( to_tsvector('russian', extra_data->>'address' )" />
</Index>

But it doesn't work.
Instead, I got an index
CREATE INDEX ticket_extra_data_gin ON ticket_extra_data USING btree (extra_data)

database is PostgreSQL

[root]

Hi,

Try using the DBObject with Do() in a package setup of your sopm


- Roy

[edi]

Thanks a lot!
It works!.