Re: [sqlalchemy] Postgresql - Index on a json field

2014-07-06 Thread Phillip Aquilina
Great, thanks again for the replies and thanks for the awesome tool. On Saturday, July 5, 2014 1:28:34 PM UTC-7, Michael Bayer wrote: On 7/5/14, 3:14 PM, Phillip Aquilina wrote: I finally had a chance to try this with the inspector and quickly discovered it doesn't support expression

Re: [sqlalchemy] Postgresql - Index on a json field

2014-07-05 Thread Phillip Aquilina
this is not yet supported that I should be worried about? On Wednesday, July 2, 2014 10:35:02 AM UTC-7, Phillip Aquilina wrote: Perfect thanks Mike. On Wednesday, July 2, 2014 10:17:17 AM UTC-7, Michael Bayer wrote: On 7/2/14, 11:38 AM, Phillip Aquilina wrote: This worked as described. Thanks

Re: [sqlalchemy] Postgresql - Index on a json field

2014-07-02 Thread Phillip Aquilina
this functionality but it doesn't look like it's been implemented? Is there a normal workaround for this? On Tuesday, July 1, 2014 10:03:40 AM UTC-7, Phillip Aquilina wrote: Ah! I'll give that a try. Thanks Mike. On Monday, June 30, 2014 10:23:13 PM UTC-7, Michael Bayer wrote: per the SO answer

Re: [sqlalchemy] Postgresql - Index on a json field

2014-07-02 Thread Phillip Aquilina
Perfect thanks Mike. On Wednesday, July 2, 2014 10:17:17 AM UTC-7, Michael Bayer wrote: On 7/2/14, 11:38 AM, Phillip Aquilina wrote: This worked as described. Thanks again. I have a followup question. It doesn't seem like there's an analog to table.create(checkfirst=True

Re: [sqlalchemy] Postgresql - Index on a json field

2014-07-01 Thread Phillip Aquilina
can show me at http://www.postgresql.org/docs/9.4/static/datatype-json.html or wherever what specific DDL you're looking for, you can simply emit it using engine.execute(ddl). On 6/30/14, 11:02 PM, Phillip Aquilina wrote: Thanks for replying. I've read through that doc and I still don't

[sqlalchemy] Postgresql - Index on a json field

2014-06-30 Thread Phillip Aquilina
Using postgresql, I have a JSON type column. My understanding from their docs was that only jsonb columns could have an index created on them (a feature of postgresql 9.4) but then I found an SO answer http://stackoverflow.com/questions/17807030/how-to-create-index-on-json-field-in-postgres-9-3

Re: [sqlalchemy] Postgresql - Index on a json field

2014-06-30 Thread Phillip Aquilina
data inside the column. - Phil On Monday, June 30, 2014 6:07:51 PM UTC-7, Michael Bayer wrote: SQLAlchemy's API allows CREATE INDEX via the Index construct: http://docs.sqlalchemy.org/en/rel_0_9/core/constraints.html?highlight=index#indexes On 6/30/14, 6:21 PM, Phillip Aquilina wrote