diff options
| author | Bruce Momjian | 2001-01-22 16:35:35 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2001-01-22 16:35:35 +0000 |
| commit | 0fada37f5d5a0148fb63f6dc02b50622601626a6 (patch) | |
| tree | 6d07e151834f6def0f2c954172940b47708e194e /doc/src/FAQ/FAQ.html | |
| parent | 7e0919136abd69715ab8f254e172d40c09ae6236 (diff) | |
Update FAQ.
Diffstat (limited to 'doc/src/FAQ/FAQ.html')
| -rw-r--r-- | doc/src/FAQ/FAQ.html | 11 |
1 files changed, 6 insertions, 5 deletions
diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index 2ef4f1eceee..420754e2e6f 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -1224,8 +1224,8 @@ Lobby your company to join W3C, see http://www.w3.org/Consortium <H4><A name="4.24">4.24</A>) How do I do an <I>outer</I> join?<BR> </H4> - <P>PostgreSQL 7.1 and later supports outer joins. Here are two - examples:</P> + <P>PostgreSQL 7.1 and later supports outer joins using the SQL + standard syntax. Here are two examples:</P> <PRE> SELECT * FROM t1 LEFT OUTER JOIN t2 ON (t1.col = t2.col); @@ -1235,9 +1235,10 @@ or SELECT * FROM t1 LEFT OUTER JOIN t2 USING (col); </PRE> - These identical queries join t1.col to t2.col, and return any - unjoined rows in t1. A <SMALL>RIGHT</SMALL> join would return - unjoined rows of table t2. A <SMALL>FULL</SMALL> join would return + These identical queries join t1.col to t2.col, and also return any + unjoined rows in t1 (those with no match in t2). A + <SMALL>RIGHT</SMALL> join would add unjoined rows of t2. A + <SMALL>FULL</SMALL> join would return the matched rows plus all unjoined rows from t1 and t2. The word <SMALL>OUTER</SMALL> is optional and is assumed in <SMALL>LEFT</SMALL>, <SMALL>RIGHT</SMALL>, and <SMALL>FULL</SMALL> joins. Ordinary joins |