diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2018-08-09 16:19:32 -0400 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2018-08-09 16:19:32 -0400 |
| commit | 58a36f91b36f30603e5983f19d26c67941cefd3a (patch) | |
| tree | d0b0bd1e59fdeea94957a47d6e6f68fadb115eec | |
| parent | a015ae54a7fd5d613470033d624879804f629fae (diff) | |
| download | postgresql-58a36f91b36f30603e5983f19d26c67941cefd3a.tar.gz postgresql-58a36f91b36f30603e5983f19d26c67941cefd3a.zip | |
Add RECURSIVE to documentation index
Author: Daniel Vérité <daniel@manitou-mail.org>
Reviewed-by: Fabien COELHO <coelho@cri.ensmp.fr>
Discussion: https://postgr.es/m/76d905d7-7eb7-4574-b6ec-a0ca3a1523c0@manitou-mail.org
| -rw-r--r-- | doc/src/sgml/queries.sgml | 4 | ||||
| -rw-r--r-- | doc/src/sgml/ref/create_view.sgml | 7 |
2 files changed, 10 insertions, 1 deletions
diff --git a/doc/src/sgml/queries.sgml b/doc/src/sgml/queries.sgml index b72be9bf716..88bc1896468 100644 --- a/doc/src/sgml/queries.sgml +++ b/doc/src/sgml/queries.sgml @@ -1981,6 +1981,10 @@ GROUP BY region, product; </para> <para> + <indexterm> + <primary>RECURSIVE</primary> + <secondary>in common table expressions</secondary> + </indexterm> The optional <literal>RECURSIVE</literal> modifier changes <literal>WITH</literal> from a mere syntactic convenience into a feature that accomplishes things not otherwise possible in standard SQL. Using diff --git a/doc/src/sgml/ref/create_view.sgml b/doc/src/sgml/ref/create_view.sgml index b325c1be50f..e7a7e9fae27 100644 --- a/doc/src/sgml/ref/create_view.sgml +++ b/doc/src/sgml/ref/create_view.sgml @@ -82,7 +82,12 @@ CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] [ RECURSIVE ] VIEW <replaceable class </varlistentry> <varlistentry> - <term><literal>RECURSIVE</literal></term> + <term><literal>RECURSIVE</literal> + <indexterm zone="sql-createview"> + <primary>RECURSIVE</primary> + <secondary>in views</secondary> + </indexterm> + </term> <listitem> <para> Creates a recursive view. The syntax |