Hello, Using SQLAlchemy 0.7.9 and Flask-SQLAlchhemy 0.16, I want to use Postgres array.
So my model is as follow : from sqlalchemy.dialects.postgresql import ARRAY class Mark(db.Model): __tablename__ = 'mark' id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(200), unique=True) url = db.Column(db.String(200), unique=True) description = db.Column(db.Text()) comment = db.Column(db.Text()) tags = db.Column(ARRAY(db.String)) author = db.relationship('User', backref=db.backref('user', lazy='joined')) created_at = db.Column(db.DateTime) updated_at = db.Column(db.DateTime) Creating the table works fine so I think the class definition is fine. I inserted a few data in the database but to retrieve them, I have some issue and can't find the right syntax for doing it right. Googling I found some keys but note work so far : - Using func.any() - Model.column_array.op("@>")(ARRAY("hello", "world") - and a few others. Thanks in advance for your help, Nicolas -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/y8wqQFTE-ZQJ. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.