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
<https://www.postgresql.org/docs/current/static/sql-select.html#SQL-WITH&gt;*

--
*Melvin Davidson*
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.

Best Regards,

On Thu, Dec 28, 2017 at 4:32 PM, Melvin Davidson <melvin6925@gmail.com>
wrote: