diff options
Diffstat (limited to 'doc/src/sgml/sql.sgml')
| -rw-r--r-- | doc/src/sgml/sql.sgml | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/doc/src/sgml/sql.sgml b/doc/src/sgml/sql.sgml index 3e3c32b89f..238e8b3005 100644 --- a/doc/src/sgml/sql.sgml +++ b/doc/src/sgml/sql.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/sql.sgml,v 1.43 2007/01/09 02:14:10 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/sql.sgml,v 1.44 2007/01/31 20:56:19 momjian Exp $ --> <chapter id="sql-intro"> <title>SQL</title> @@ -173,9 +173,9 @@ PART: 4 | 3 </para> <para> - The tables PART and SUPPLIER may be regarded as + The tables PART and SUPPLIER can be regarded as <firstterm>entities</firstterm> and - SELLS may be regarded as a <firstterm>relationship</firstterm> + SELLS can be regarded as a <firstterm>relationship</firstterm> between a particular part and a particular supplier. </para> @@ -949,7 +949,7 @@ SELECT PNAME, PRICE </para> <para> - Arithmetic operations may be used in the target list and in the WHERE + Arithmetic operations can be used in the target list and in the WHERE clause. For example if we want to know how much it would cost if we take two pieces of a part we could use the following query: @@ -1059,7 +1059,7 @@ select sname, pname from supplier A joined table, created using JOIN syntax, is a table reference list item that occurs in a FROM clause and before any WHERE, GROUP BY, or HAVING clause. Other table references, including table names or - other JOIN clauses, may be included in the FROM clause if separated + other JOIN clauses, can be included in the FROM clause if separated by commas. JOINed tables are logically like any other table listed in the FROM clause. </para> @@ -1239,7 +1239,7 @@ select sname, pname from supplier <para> JOINs of all types can be chained together or nested where either or both of <replaceable class="parameter">T1</replaceable> and - <replaceable class="parameter">T2</replaceable> may be JOINed tables. + <replaceable class="parameter">T2</replaceable> can be JOINed tables. Parenthesis can be used around JOIN clauses to control the order of JOINs which are otherwise processed left to right. </para> @@ -1405,7 +1405,7 @@ SELECT S.SNO, S.SNAME, COUNT(SE.PNO) <para> Note that for a query using GROUP BY and aggregate functions to make sense, the target list can only refer directly to - the attributes being grouped by. Other attributes may only be used + the attributes being grouped by. Other attributes can only be used inside the arguments of aggregate functions. Otherwise there would not be a unique value to associate with the other attributes. </para> @@ -1825,7 +1825,7 @@ CREATE INDEX I ON SUPPLIER (SNAME); <title>Create View</title> <para> - A view may be regarded as a <firstterm>virtual table</firstterm>, + A view can be regarded as a <firstterm>virtual table</firstterm>, i.e. a table that does not <emphasis>physically</emphasis> exist in the database but looks to the user |