Re: 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.

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.