SQLAlchemy will send exactly what string you want. But you have to figure out
what Postgresql wants. Maybe you don't want those quotes in there?
func.discounted_price(text('packages.*')) won't quote like that:
>>> from sqlalchemy import func, text
>>> print func.discounted_price(text('packages.*'))
discounted_price(packages.*)
>>>
On Sep 8, 2014, at 12:10 PM, Tyler Bondy <[email protected]> wrote:
> Hmm, I've tried that and gotten the following error:
>
> ProgrammingError: (ProgrammingError) function discounted_price(unknown) is
> not unique
> LINE 1: SELECT discounted_price('packages.*') AS discounted_price_1
> ^
> HINT: Could not choose a best candidate function. You might need to add
> explicit type casts.
> 'SELECT discounted_price(%(discounted_price_2)s) AS discounted_price_1 \n
> LIMIT %(param_1)s' {'param_1': 1, 'discounted_price_2': 'packages.*'}
>
> --
> 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.
--
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.
