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
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