Thread: documentation help
On Thu, Dec 28, 2017 at 9:22 AM, Paul Tilles <paul.tilles@noaa.gov> wrote:
I just read the interesting article by Hans-Juergen Schoenig describing how to speed up GROUP BY and JOIN. In the article, he mentions using an "optimization barrier" where the SQL is
WITH x AS
Can somebody tell me where in the postgres docs I can find information about this SQL?
TIA.
Paul Tilles
>Can somebody tell me where in the postgres docs I can find information about this SQL?
Since you did not indicate which VERSION of PostgreSQL you are using, I will point you to the latest release.
The WITH clause is part of the standard SELECT statement.
Just search for "WITH Clause" in this url.
--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
The doc page you're seeking is at https://www.postgresql.org/docs/current/static/queries-with.html
once inside the page, you can switch to another version if you wish to.
once inside the page, you can switch to another version if you wish to.
Best Regards,
On Thu, Dec 28, 2017 at 4:32 PM, Melvin Davidson <melvin6925@gmail.com> wrote:
On Thu, Dec 28, 2017 at 9:22 AM, Paul Tilles <paul.tilles@noaa.gov> wrote:I just read the interesting article by Hans-Juergen Schoenig describing how to speed up GROUP BY and JOIN. In the article, he mentions using an "optimization barrier" where the SQL is
WITH x AS
Can somebody tell me where in the postgres docs I can find information about this SQL?
TIA.
Paul Tilles>Can somebody tell me where in the postgres docs I can find information about this SQL?Since you did not indicate which VERSION of PostgreSQL you are using, I will point you to the latest release.The WITH clause is part of the standard SELECT statement.Just search for "WITH Clause" in this url.
--Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.