Re: "writable CTEs"

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: "writable CTEs"
Дата
Msg-id AANLkTimHP3Ee6p91FSLWi5+QhTTMQK_dQSb+JfLg3QLG@mail.gmail.com
обсуждение исходный текст
Ответ на Re: "writable CTEs"  (David Fetter <david@fetter.org>)
Ответы Re: "writable CTEs"  (Peter Geoghegan <peter.geoghegan86@gmail.com>)
Re: "writable CTEs"  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-hackers
On Tue, Dec 28, 2010 at 12:45 AM, David Fetter <david@fetter.org> wrote:
> I don't see how people can be relying on links to 9.1-to-be's
> documentation.

Well, it's always handy when the filenames are the same across
versions.  Ever looked at the 9.0 documentation for something and then
modified the URL to see what it looked like in 8.1 or something?

>> The main change I've made is: "WITH queries, also referred to as
>> Common table expressions or CTEs, provide a way to write subqueries
>> for use as part of a larger query". I'm concerned that this might
>> not be strictly correct, because the term "WITH query" may not be
>> exactly equivalent to the term "CTE" - WITH queries are comprised of
>> one or more CTEs, plus a main query.  Or are they?
>
> They are. :)

No, actually I think Peter has it right.  A query with one or more
common table expressions is a WITH-query.  This is a subtle difference
but could affect the way that things are phrased in the documentation.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: estimating # of distinct values
Следующее
От: Robert Haas
Дата:
Сообщение: Re: UPDATE pg_catalog.pg_proc.prosrc OK?