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
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 =
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, MetaData(),
Column(id, Integer, primary_key
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
