[sqlalchemy] Re: Concatenating column names and text() clauses

2008-09-03 Thread Jeff
On Aug 21, 5:25 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Aug 21, 2008, at 4:28 PM, Jeff wrote: Hello.  I'm trying to writing something to generate full text searches for postgres.  Here's the function I've got so far: from sqlalchemy import sql import operator def

[sqlalchemy] Re: Concatenating column names and text() clauses

2008-09-03 Thread Michael Bayer
On Sep 3, 2008, at 11:09 AM, Jeff wrote: in general, text() is intended primarily for fully constructed SQL statements, and does not implement the semantics of an element used within an expression. For individual literal components, use the literal() function which produces a bind

[sqlalchemy] Re: Concatenating column names and text() clauses

2008-08-21 Thread az
if u start with the text, would it work? text(abc) + column text(abc) + text(dsa) text(abc) + column + text(abc) text(abc) + column1 + column2 On Thursday 21 August 2008 23:28:54 Jeff wrote: Hello. I'm trying to writing something to generate full text searches for postgres. Here's the

[sqlalchemy] Re: Concatenating column names and text() clauses

2008-08-21 Thread Michael Bayer
On Aug 21, 2008, at 4:28 PM, Jeff wrote: Hello. I'm trying to writing something to generate full text searches for postgres. Here's the function I've got so far: from sqlalchemy import sql import operator def full_text(fields, text): def alternate(items): for i in