Hi everyone,
I'm trying to implement a nested JSONB index on a nested field in the json
file. I searched through internet and came at the conclusion that I had to
create it manually.
so that's where I am.
op.create_index('ix_law_search_vector', 'law', ['search_vector'],
unique=False, postgresql_using='gin')
first of all, I don't understand the 3rd argument. what does this
represent? the name of the index?
this is what should be. but my problem is that my desire index is very deep
in the JSONB.
that's what I've to target :
Image.image_metadata['afield']['anotherfield']['fieldindex']
I want to create an index on fieldindex.
but if I do :
op.create_index('uri', ['search_vector'], unique=False,
postgresql_using='gin')
as there is a lot of field 'uri' in the json, will it index all this fields
in 1 ?
(I'm new to sqlalchemy, I usually use the django orm, so sorry in advance).
Thanks for answers
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
