No support for the TABLESAMPLE clause (SQL 2003 / PostgreSQL)
There doesn't seem to be any built-in support for the TABLESAMPLE clause (searched docs and asked on SO [3]).
[1] https://www.postgresql.org/docs/9.5/static/sql-select.html [2] http://users.atw.hu/sqlnut/sqlnut2-chp-1-sect-2.html [3] https://stackoverflow.com/questions/37429476/how-to-tablesample-with-sqlalchemy
Comments (4)
-
repo owner -
repo owner - changed milestone to 1.1
- changed component to sql
- marked as enhancement
-
reporter Wow. That is pretty unbelievable. Gotta love time travelers.
EDIT: Then again, nevermind! It seems the guy who answered my SO question made that PR. That's awesome.
-
repo owner - changed status to resolved
Add TABLESAMPLE clause support.
The TABLESAMPLE clause allows randomly selecting an approximate percentage of rows from a table. At least DB2, Microsoft SQL Server and recent Postgresql support this standard clause.
Fixes:
#3718Change-Id: I3fb8b9223e12a57100df30876b461884c58d72fa Pull-request: https://github.com/zzzeek/sqlalchemy/pull/277→ <<cset 20f2f5b169d3>>
- Log in to comment
I'm assuming this is related to the PR just sent today at https://github.com/zzzeek/sqlalchemy/pull/277 (now in gerrit at https://gerrit.sqlalchemy.org/#/c/88/).
If not, it would be the most unbelievable coincidence.