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.
Best Regards, On Thu, Dec 28, 2017 at 4:32 PM, Melvin Davidson <melvin6...@gmail.com> wrote: > > > On Thu, Dec 28, 2017 at 9:22 AM, Paul Tilles <paul.til...@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.* > > > *https://www.postgresql.org/docs/current/static/sql-select.html#SQL-WITH > <https://www.postgresql.org/docs/current/static/sql-select.html#SQL-WITH>* > > -- > *Melvin Davidson* > I reserve the right to fantasize. Whether or not you > wish to share my fantasy is entirely up to you. >
