[sqlalchemy] Re: text() TextClauses and like literals

2008-09-17 Thread Michael Bayer
On Sep 17, 2008, at 9:19 AM, Mark Mitchell wrote: The code to replicate this exception is pretty simple: count = con.scalar(select(['count(*)'], from_obj=my_table, whereclause=text('mytable.column like \'%\'')) That is my error, here is my

[sqlalchemy] Re: text() TextClauses and like literals

2008-09-17 Thread Mark Mitchell
Thanks! That is good to know. Having trouble finding the docs for psycopg2 -- any idea off the top of your head what the escape syntax is for %? (When I put in '%%', pyscopg2 outputted %%, not %, to postgres (but didn't throw the exception)). I found the home page for pyscopg2 but no docs.