From: Tom Lane <tgl@sss.pgh.pa.us>
To: Gunther Schadow <raj@gusw.net>
Cc: Justin Pryzby <pryzby@telsasoft.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: When you really want to force a certain join type?
Date: Thu, 29 Dec 2022 02:52:10 -0500
Message-ID: <492412.1672300330@sss.pgh.pa.us> (raw)
In-Reply-To: <c0cf4fbd-a5db-e5dc-935f-399a355c02ee@gusw.net>
References: <70b2ee7b-8e8b-d884-8ca2-590a242308b8@gusw.net>
<20221228154837.GX1153@telsasoft.com>
<c0cf4fbd-a5db-e5dc-935f-399a355c02ee@gusw.net>
Gunther Schadow <raj@gusw.net> writes:
> Also, why even use the RECURSIVE keyword, DB2 didn't need it, and the
> query analyzer should immediately see the recursion, so no need to have
> that keyword.
Our reading of the SQL spec is that it's required. The scope of
visibility of CTE names is different depending on whether you
write RECURSIVE or not, so it's not a question of "the query analyzer
should see it": the analyzer is required NOT to see it.
DB2 generally has a reputation for agreeing with the spec,
so I'm surprised to hear that they're not doing this per spec.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, raj@gusw.net, pryzby@telsasoft.com, pgsql-performance@lists.postgresql.org
Subject: Re: When you really want to force a certain join type?
In-Reply-To: <492412.1672300330@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox