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(*
oh, a HUGE thanks!
--
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@googleg
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
"sq
It's never 'untrusted user input', but could be 'worrisome junior developer
input'.
I didn't realize that I could attach the bindparam to `text()`. This is
exactly what I should have wanted in the first place!
--
You received this message because you are subscribed to the Google Groups
"sqlal
On 4/3/15 3:10 PM, Jonathan Vanasco wrote:
> I have an include file that generates a handful of timestamp clauses:
>
> def sql_now():
> return sqlalchemy.sql.text("(CURRENT_TIMESTAMP AT TIME ZONE 'UTC')")
>
> def sql_now_minus_10_minutes():
> return sqlalchemy.sql.text("(CURRENT_TIMESTAMP AT TIME
I have an include file that generates a handful of timestamp clauses:
def sql_now():
return sqlalchemy.sql.text("(CURRENT_TIMESTAMP AT TIME ZONE 'UTC')")
def sql_now_minus_10_minutes():
return sqlalchemy.sql.text("(CURRENT_TIMESTAMP AT TIME ZONE 'UTC' -
INTERVAL '10 MINUTES')")
One of them need
SQLAlchemy release 1.0.0b5 is now available.
This release is yet another set of fixes for issues reported
by beta testers. At this point, 1.0.0 is ready to go and should
be released very soon.
In preparation for 1.0.0, production installations that haven't yet been
tested in the 1.0 series shoul
Michael,
Thanks - sorry to have wasted your time. It seems I gave up on Googling my
stack trace too soon.
Thanks,
Evan James
--
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