diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2022-03-23 10:09:18 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2022-03-23 10:09:18 -0400 |
| commit | c565c470517e1cc70a7f33d1ad3d3256935f1121 (patch) | |
| tree | 740a99da828f413adcffe450f828a87e0d10fde7 /lib/sqlalchemy/dialects/postgresql/base.py | |
| parent | 6652c62bd90a455843c77f41acd50af920126351 (diff) | |
| download | sqlalchemy-c565c470517e1cc70a7f33d1ad3d3256935f1121.tar.gz | |
fix generate series example
this just drove me nuts because it didn't include
render_derived(), doesn't run on PG as given
Change-Id: I5d39336231c97b6cd5477644a718282709db2e1f
Diffstat (limited to 'lib/sqlalchemy/dialects/postgresql/base.py')
| -rw-r--r-- | lib/sqlalchemy/dialects/postgresql/base.py | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/lib/sqlalchemy/dialects/postgresql/base.py b/lib/sqlalchemy/dialects/postgresql/base.py index a1401ea03..bec987c46 100644 --- a/lib/sqlalchemy/dialects/postgresql/base.py +++ b/lib/sqlalchemy/dialects/postgresql/base.py @@ -1182,11 +1182,14 @@ Examples from PostgreSQL's reference documentation follow below: >>> from sqlalchemy import select, func >>> stmt = select( - ... func.generate_series(4, 1, -1).table_valued("value", with_ordinality="ordinality") + ... func.generate_series(4, 1, -1). + ... table_valued("value", with_ordinality="ordinality"). + ... render_derived() ... ) >>> print(stmt) SELECT anon_1.value, anon_1.ordinality - FROM generate_series(:generate_series_1, :generate_series_2, :generate_series_3) WITH ORDINALITY AS anon_1 + FROM generate_series(:generate_series_1, :generate_series_2, :generate_series_3) + WITH ORDINALITY AS anon_1(value, ordinality) .. versionadded:: 1.4.0b2 |