Michael,

On 01/16/2012 05:53 PM, Michael Bayer wrote:


On Jan 16, 2012, at 11:46 AM, werner wrote:

I would like to do this type of thing:

namesandvar = column_property(names + " " + variety)

and use it e.g. like:

query(db.Cellarbook).filter(db.Drinkinfo.namesandvar.contains(u'menu'))

But Firebird SQL doesn't like the "+" operator, it throws an error "Strings cannot be added or subtracted in dialect 3".

Is there an alternative which would work for both FB and Postgresql?

the + should be coming out as || if "names" and "variety" are both of String type.
Hhm, yeap it works if I use "sa.Unicode". So I must have messed up with my custom type.

Thanks for your quick reply
Werner

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

Reply via email to