Hi,
I think I don't see documentation on the 'match' operator that works
differently according to db backend.
If I just missed it please point me to the right place, otherwise
can you give me some more info?
How can it be used with sqlite: can it work as ~ in postgres?
If I try lo used it as in:
session.query(mapper).filter(title_col.match('a'))
I get back a:
<class 'sqlalchemy.exc.OperationalError'>: (OperationalError) unable
to use function MATCH in the requested context u'SELECT movie.id AS
movie_id, movie.title AS movie_title, movie.description AS
movie_description, movie.year AS movie_year, movie.date_release AS
movie_date_release, movie.director_id AS movie_director_id \nFROM
movie \nWHERE movie.title MATCH ? ORDER BY director_id \n LIMIT 200
OFFSET 0' ['a']
TIA
sandro
*:-)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
