On Thu, Apr 18, 2019 at 4:00 PM Markus Elfring <markus.elfr...@web.de> wrote: > > > there's no technical reason the "1" needs to render inline > > How does this information fit to the code “having(func.count(Address.id) > 2)” > from an example? > https://docs.sqlalchemy.org/en/13/orm/query.html#sqlalchemy.orm.query.Query.having
it will generate the same SQL and provide "2" for the bound value instead of "1". > > > > and SQLAlchemy defaults literal values to being bound parameters. > > Did I overlook a detail from the software documentation? see here: https://docs.sqlalchemy.org/en/13/core/tutorial.html#operators > > > If you'd like it to say "1", then use having(func.count("*") > > > literal_column("1")). > > I have got the generated codes “count(:count_1) AS "C"” and “HAVING > count(:count_2) > 1” > then for my query approach. > Which details should I adjust further? I don't know what SQL you are attempting to render. > > Regards, > Markus -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- 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 sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.