I think you can get this with select.prefix_with():

http://docs.sqlalchemy.org/en/rel_0_9/core/selectable.html?highlight=prefix#sqlalchemy.sql.expression.Select.prefix_with



On 4/3/15 8:22 PM, Kristi Tsukida wrote:
> Redshift supports a modifier "approximate" as in
>
> SELECT APPROXIMATE COUNT(*)
> FROM my_table;
>
> Is there a way to get this with func.count()?
>
> Thanks
> -Kristi
>
> http://docs.aws.amazon.com/redshift/latest/dg/r_COUNT.html
> -- 
> 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
> <mailto:sqlalchemy+unsubscr...@googlegroups.com>.
> To post to this group, send email to sqlalchemy@googlegroups.com
> <mailto:sqlalchemy@googlegroups.com>.
> 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 sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

Reply via email to