regex - Check If first character is "+" -
how can detect string start "+"
i tried
^\s*?\+.*$
no help.
p.s: have 1 line alltime.
you don't need \s*?, have use:
^\+ or... ^[+] in case want check complete string, can use:
^\+.*$ python - How to create jsonb index using GIN on SQLAlchemy? -
here's current code creating index jsonb. index("mytable_data_idx_id_key", mytable.data['id'].astext, postgresql_using='gin') but got error. sqlalchemy.exc.programmingerror: (psycopg2.programmingerror) data type text has no default operator class access method "gin" hint: must specify operator class index or define default operator class data type. [sql: "create index event_data_idx_id_key on event using gin ((data ->> 'id'))"] is there way create index on sqlalchemy? the postgresql specific sqlalchemy docs @ http://docs.sqlalchemy.org/en/latest/dialects/postgresql.html#operator-classes mention postgresql_ops dictionary provide "operator class" used postgresql, , provide example illustrating use: index('my_index', my_table.c.id, my_table.c.data, postgresql_ops={ 'data': 'text_pattern_ops', ...
Comments
Post a Comment