Commit0fada37

committed

Update FAQ.

1 parent7e09191 commit0fada37Copy full SHA for 0fada37

File tree

+14

-11

lines changed

+14

-11

lines changed

Lines changed: 8 additions & 6 deletions

Original file line number	Diff line number	Diff line change
`@@ -948,19 +948,21 @@ SELECT *`
`948`	`948`
`949`	`949`	`4.24) How do I do an outer join?`
`950`	`950`
`951`		`- PostgreSQL 7.1 and later supports outer joins. Here are two examples:`
	`951`	`+ PostgreSQL 7.1 and later supports outer joins using the SQL standard`
	`952`	`+ syntax. Here are two examples:`
`952`	`953`	`SELECT *`
`953`	`954`	`FROM t1 LEFT OUTER JOIN t2 ON (t1.col = t2.col);`
`954`	`955`
`955`	`956`	`or`
`956`	`957`	`SELECT *`
`957`	`958`	`FROM t1 LEFT OUTER JOIN t2 USING (col);`
`958`	`959`
`959`		`- These identical queries join t1.col to t2.col, and return any unjoined`
`960`		`- rows in t1. A RIGHT join would return unjoined rows of table t2. A`
`961`		`- FULL join would return unjoined rows from t1 and t2. The word OUTER is`
`962`		`- optional and is assumed in LEFT, RIGHT, and FULL joins. Ordinary joins`
`963`		`- are called INNER joins.`
	`960`	`+ These identical queries join t1.col to t2.col, and also return any`
	`961`	`+ unjoined rows in t1 (those with no match in t2). A RIGHT join would`
	`962`	`+ add unjoined rows of t2. A FULL join would return the matched rows`
	`963`	`+ plus all unjoined rows from t1 and t2. The word OUTER is optional and`
	`964`	`+ is assumed in LEFT, RIGHT, and FULL joins. Ordinary joins are called`
	`965`	`+ INNER joins.`
`964`	`966`
`965`	`967`	`In previous releases, outer joins can be simulated using UNION and NOT`
`966`	`968`	`IN. For example, when joining tab1 and tab2, the following query does`

Lines changed: 6 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -1224,8 +1224,8 @@ <H4><A name="4.23">4.23</A>) Why are my subqueries using`
`1224`	`1224`	`<H4><Aname="4.24">4.24</A>) How do I do an<I>outer</I> join?<BR>`
`1225`	`1225`	`</H4>`
`1226`	`1226`
`1227`		`-<P>PostgreSQL 7.1 and later supports outer joins. Here are two`
`1228`		`- examples:</P>`
	`1227`	`+<P>PostgreSQL 7.1 and later supports outer joins using the SQL`
	`1228`	`+standard syntax. Here are twoexamples:</P>`
`1229`	`1229`	`<PRE>`
`1230`	`1230`	`SELECT *`
`1231`	`1231`	`FROM t1 LEFT OUTER JOIN t2 ON (t1.col = t2.col);`
`@@ -1235,9 +1235,10 @@ <H4><A name="4.24">4.24</A>) How do I do an <I>outer</I> join?<BR>`
`1235`	`1235`	`SELECT *`
`1236`	`1236`	`FROM t1 LEFT OUTER JOIN t2 USING (col);`
`1237`	`1237`	`</PRE>`
`1238`		`- These identical queries join t1.col to t2.col, and return any`
`1239`		`- unjoined rows in t1. A<SMALL>RIGHT</SMALL> join would return`
`1240`		`- unjoined rows of table t2. A<SMALL>FULL</SMALL> join would return`
	`1238`	`+ These identical queries join t1.col to t2.col, and also return any`
	`1239`	`+ unjoined rows in t1 (those with no match in t2). A`
	`1240`	`+<SMALL>RIGHT</SMALL> join would add unjoined rows of t2. A`
	`1241`	`+<SMALL>FULL</SMALL> join would return the matched rows plus all`
`1241`	`1242`	`unjoined rows from t1 and t2. The word<SMALL>OUTER</SMALL> is`
`1242`	`1243`	`optional and is assumed in<SMALL>LEFT</SMALL>,`
`1243`	`1244`	`<SMALL>RIGHT</SMALL>, and<SMALL>FULL</SMALL> joins. Ordinary joins`

Comments

(0)