Ahh I think I've got it now, thanks a bunch.
On Monday, September 8, 2014 12:13:41 PM UTC-4, Michael Bayer wrote:
>
> 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] <javascript:>>
> 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] <javascript:>.
> To post to this group, send email to [email protected]
> <javascript:>.
> 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.
