with_cte_docs.patch

text/x-diff

Filename: with_cte_docs.patch

Type: text/x-diff

Part: 0

Message: REVIEW: "writable CTEs" - doc patch

Patch

Same data as JSON: GET /api/v1/attachments/:id/patch the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes. API reference →

Format: context

File	+	−
doc/src/sgml/acronyms.sgml	9	0
doc/src/sgml/queries.sgml	3	0

*** a/doc/src/sgml/acronyms.sgml
--- b/doc/src/sgml/acronyms.sgml
***************
*** 99,104 ****
--- 99,113 ----
     </varlistentry>
  
     <varlistentry>
+     <term><acronym>CTE</acronym></term>
+     <listitem>
+      <para>
+       <link linkend="queries-with">Common Table Expression</link>
+      </para>
+     </listitem>
+    </varlistentry>
+ 
+    <varlistentry>
      <term><acronym>CVE</acronym></term>
      <listitem>
       <para>
*** a/doc/src/sgml/queries.sgml
--- b/doc/src/sgml/queries.sgml
***************
*** 1525,1531 **** SELECT <replaceable>select_list</replaceable> FROM <replaceable>table_expression
  
  
   <sect1 id="queries-with">
!   <title><literal>WITH</literal> Queries</title>
  
    <indexterm zone="queries-with">
     <primary>WITH</primary>
--- 1525,1531 ----
  
  
   <sect1 id="queries-with">
!   <title><literal>WITH</literal> Queries (Common Table Expressions)</title>
  
    <indexterm zone="queries-with">
     <primary>WITH</primary>
***************
*** 1539,1545 **** SELECT <replaceable>select_list</replaceable> FROM <replaceable>table_expression
  
    <para>
     <literal>WITH</> provides a way to write subqueries for use in a larger
!    query.  The subqueries can be thought of as defining
     temporary tables that exist just for this query.  One use of this feature
     is to break down complicated queries into simpler parts.  An example is:
  
--- 1539,1546 ----
  
    <para>
     <literal>WITH</> provides a way to write subqueries for use in a larger
!    query.  The subqueries, which are often referred to as Common Table
!    Expressions or <acronym>CTE</acronym>s, can be thought of as defining
     temporary tables that exist just for this query.  One use of this feature
     is to break down complicated queries into simpler parts.  An example is: