[sqlalchemy] PostgreSQL Tsvector type

2013-12-02 Thread Noufal Ibrahim
Hello everyone, I've been trying to get the postgreSQL tsvector type work with SQLAlchemy without dropping into raw SQL. I was mostly interested in queries and the DDL to create the initial table. Through some trial and error, I have a setup working which I've detailed here

Re: [sqlalchemy] PostgreSQL Tsvector type

2013-12-02 Thread Michael Bayer
the TsVector type looks perfect! if you were to package that up for inclusion, it would likely subclass TypeEngine and you’d implement PGTypeCompiler.visit_TSVECTOR.we appear to have a little bit of “tsvector” code already (we implement the “match” operator as %s @@ to_tsquery(%s)” ) but