Re: [sqlalchemy] Cannot reproduce subquery involving difference of scalar and vector (generate_series)

2018-11-14 Thread Mike Bayer
for SELECTING from PG's special functions, see if you can find a solution in the many recipes at https://bitbucket.org/zzzeek/sqlalchemy/issues/3566/figure-out-how-to-support-all-of-pgs for now. I haven't looked closely at your specific problem yet but it seems to correspond with those. On Wed,

[sqlalchemy] Cannot reproduce subquery involving difference of scalar and vector (generate_series)

2018-11-14 Thread Tomáš Sandrini
Hi everyone, I have a database of some `items` which have a range (tsarange => DateTimeRange) column that usually ranges in intervals of a bunch of seconds and I basically want to create an availability statistics of those items (based on their `lower(Item.range)`) for some period (month/day)