Commit3e76c9a

committed

Move ALL out of UNION|INTERSECT|EXCEPT syntax.

Alvaro Herrera

1 parent749fe03 commit3e76c9aCopy full SHA for 3e76c9a

File tree

-6

lines changed

-6

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$Header: /cvsroot/pgsql/doc/src/sgml/ref/select.sgml,v 1.48 2001/10/20 02:55:38 momjian Exp $`
	`2`	`+$Header: /cvsroot/pgsql/doc/src/sgml/ref/select.sgml,v 1.49 2001/10/23 16:42:36 momjian Exp $`
`3`	`3`	`Postgres documentation`
`4`	`4`	`-->`
`5`	`5`
`@@ -26,7 +26,7 @@ SELECT [ ALL \| DISTINCT [ ON ( <replaceable class="PARAMETER">expression</replac`
`26`	`26`	`[ WHERE <replaceable class="PARAMETER">condition</replaceable> ]`
`27`	`27`	`[ GROUP BY <replaceable class="PARAMETER">expression</replaceable> [, ...] ]`
`28`	`28`	`[ HAVING <replaceable class="PARAMETER">condition</replaceable> [, ...] ]`
`29`		`- [ { UNION \| INTERSECT \| EXCEPT [ ALL ] } <replaceable class="PARAMETER">select</replaceable> ]`
	`29`	`+ [ { UNION \| INTERSECT \| EXCEPT}[ ALL ] <replaceable class="PARAMETER">select</replaceable> ]`
`30`	`30`	`[ ORDER BY <replaceable class="PARAMETER">expression</replaceable> [ ASC \| DESC \| USING <replaceable class="PARAMETER">operator</replaceable> ] [, ...] ]`
`31`	`31`	`[ FOR UPDATE [ OF <replaceable class="PARAMETER">tablename</replaceable> [, ...] ] ]`
`32`	`32`	`[ LIMIT { <replaceable class="PARAMETER">count</replaceable> \| ALL } ]`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$Header: /cvsroot/pgsql/doc/src/sgml/ref/select_into.sgml,v 1.13 2001/10/22 18:14:47 petere Exp $`
	`2`	`+$Header: /cvsroot/pgsql/doc/src/sgml/ref/select_into.sgml,v 1.14 2001/10/23 16:42:36 momjian Exp $`
`3`	`3`	`Postgres documentation`
`4`	`4`	`-->`
`5`	`5`
`@@ -29,7 +29,7 @@ SELECT [ ALL \| DISTINCT [ ON ( <replaceable class="PARAMETER">expression</replac`
`29`	`29`	`[ WHERE <replaceable class="PARAMETER">condition</replaceable> ]`
`30`	`30`	`[ GROUP BY <replaceable class="PARAMETER">expression</replaceable> [, ...] ]`
`31`	`31`	`[ HAVING <replaceable class="PARAMETER">condition</replaceable> [, ...] ]`
`32`		`- [ { UNION \| INTERSECT \| EXCEPT [ ALL ] } <replaceable class="PARAMETER">select</replaceable> ]`
	`32`	`+ [ { UNION \| INTERSECT \| EXCEPT}[ ALL ] <replaceable class="PARAMETER">select</replaceable> ]`
`33`	`33`	`[ ORDER BY <replaceable class="PARAMETER">expression</replaceable> [ ASC \| DESC \| USING <replaceable class="PARAMETER">operator</replaceable> ] [, ...] ]`
`34`	`34`	`[ FOR UPDATE [ OF <replaceable class="PARAMETER">tablename</replaceable> [, ...] ] ]`
`35`	`35`	`[ LIMIT [ <replaceable class="PARAMETER">start</replaceable> , ] { <replaceable class="PARAMETER">count</replaceable> \| ALL } ]`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$Header: /cvsroot/pgsql/doc/src/sgml/sql.sgml,v 1.23 2001/10/20 02:55:38 momjian Exp $`
	`2`	`+$Header: /cvsroot/pgsql/doc/src/sgml/sql.sgml,v 1.24 2001/10/23 16:42:36 momjian Exp $`
`3`	`3`	`-->`
`4`	`4`
`5`	`5`	`<chapter id="sql">`
`@@ -861,7 +861,7 @@ SELECT [ ALL \| DISTINCT [ ON ( <replaceable class="PARAMETER">expression</replac`
`861`	`861`	`[ WHERE <replaceable class="PARAMETER">condition</replaceable> ]`
`862`	`862`	`[ GROUP BY <replaceable class="PARAMETER">expression</replaceable> [, ...] ]`
`863`	`863`	`[ HAVING <replaceable class="PARAMETER">condition</replaceable> [, ...] ]`
`864`		`- [ { UNION \| INTERSECT \| EXCEPT [ ALL ] } <replaceable class="PARAMETER">select</replaceable> ]`
	`864`	`+ [ { UNION \| INTERSECT \| EXCEPT}[ ALL ] <replaceable class="PARAMETER">select</replaceable> ]`
`865`	`865`	`[ ORDER BY <replaceable class="PARAMETER">expression</replaceable> [ ASC \| DESC \| USING <replaceable class="PARAMETER">operator</replaceable> ] [, ...] ]`
`866`	`866`	`[ FOR UPDATE [ OF <replaceable class="PARAMETER">class_name</replaceable> [, ...] ] ]`
`867`	`867`	`[ LIMIT { <replaceable class="PARAMETER">count</replaceable> \| ALL } ]`

Comments

(0)