On Oct 16, 11:41 am, Adam <[EMAIL PROTECTED]> wrote:
> I'm using Postgres 8.3 and sqlalchemy 0.5.0rc2 - when I'm doing a
> select, it seems I can't concatenate a function with another column -
> rather that use the || operator, it tries to use the || operator.
>
> Code to reproduce example:
> import sqlalchemy as sa
> from sqlalchemy import *
> from sqlalchemy.sql import *
>
> meta = MetaData()
>
> def get_pg_statement(s):
> return s.compile(bind=create_engine('postgres://'))
>
> pt = Table('people', meta,
> Column('id', Integer, primary_key=True),
> Column('first_name', String(100)),
> Column('last_name', String(100))
> )
>
> statements = (
> select([func.lower(pt.c.first_name)]),
> select([pt.c.first_name + pt.c.last_name]),
> select([func.lower(pt.c.first_name) + pt.c.first_name +
> pt.c.last_name]),
> )
>
> print sa.__version__
>
> for s in statements:
> print get_pg_statement(s)
>
> --------------------------------------------------------------------------------
>
> Output of sample (line breaks removed):
> 0.5.0rc2
> SELECT lower(people.first_name) AS lower_1 FROM people
> SELECT people.first_name || people.last_name AS anon_1 FROM people
> SELECT (lower(people.first_name) + people.first_name) ||
> people.last_name AS anon_1 FROM people
>
> Note on the third select, the + operator is used rather than ||.
>
> The following error is thrown from PostGres:
> ERROR: operator does not exist: text + character varying
> LINE 1: SELECT (lower(people.first_name) + people.first_name) ||
> peo...
> ^
> HINT: No operator matches the given name and argument type(s). You
> might need to add explicit type casts.
>
> When running "SELECT (lower(people.first_name) || people.first_name)
> || people.last_name AS anon_1 FROM people" the querey executes
> properly.
>
> Is there a workaround for this?
send type_=String to each func.lower() call, as in
func.lower(people.first_name, type_=String). This defines the return
type of the function. In some cases this is determined for you (which
we call a generic function) but apparently lower() is not yet on the
list.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
