ah, I see. Thanks Mike.
On Wednesday, October 21, 2015 at 6:19:32 PM UTC-7, Kristi Tsukida wrote:
>
> It looks like only one aliased table gets aliased correctly when joining
> to multiple aliased tables.
>
> Test case:
>
> from __future__ import print_function
> from s
It looks like only one aliased table gets aliased correctly when joining to
multiple aliased tables.
Test case:
from __future__ import print_function
from sqlalchemy import Integer, String, select, Date, and_
from sqlalchemy import Column
from sqlalchemy.ext.declarative import declarative_bas
awesome, thanks Michael!
On Friday, May 8, 2015 at 12:47:35 AM UTC-7, Kristi Tsukida wrote:
>
> It looks like in sqlalchemy >= 0.9.9 that a insert from cte doesn't get
> rendered properly.
>
> Code:
>
> from sqlalchemy import *
>
> table = Table("my_table&
It looks like in sqlalchemy >= 0.9.9 that a insert from cte doesn't get
rendered properly.
Code:
from sqlalchemy import *
table = Table("my_table", MetaData(),
Column("id", Integer, primary_key=True),
Column("name", String(30)),
)
c = table.select().cte("c")
query = c.select()
insert =
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
