> As stated in the docs:
> "Note that any name not known to func generates the function name as is
> - there is no restriction on what SQL functions can be called,
> known or unknown to SQLAlchemy, built-in or user defined."
I get an error message like "Function len(text) does not exist." if I try
something out like the following on a string field.
…
for length, \
incidence in session.query(func.len(position.label),
func.count(position.label)
).group_by(func.len(position.label)) \
.order_by(func.len(position.label)):
…
Is it interesting that the following approach seems to work instead?
…
for length, \
incidence in session.query(func.length(position.label),
func.count(position.label)
).group_by(func.length(position.label)) \
.order_by(func.length(position.label)):
…
How is the function "length" mapped to the SQL function "LEN"?
Regards,
Markus
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
