summaryrefslogtreecommitdiff
path: root/doc
diff options
context:
space:
mode:
authorBruce Momjian2000-06-12 22:36:19 +0000
committerBruce Momjian2000-06-12 22:36:19 +0000
commit6cb6d05456badf00869afde94f94bd3ef174e0ca (patch)
treedf23442e9400ffee95468e58d8bffa516026dd17 /doc
parent332f0f5fc0c42d6f5599e8ab8a6754588b73edb7 (diff)
Brand 7.1 release. Also update jdbc version in release branch.
Diffstat (limited to 'doc')
-rw-r--r--doc/bug.template2
-rw-r--r--doc/src/FAQ.html20
2 files changed, 20 insertions, 2 deletions
diff --git a/doc/bug.template b/doc/bug.template
index e279c195533..0474b58b0ec 100644
--- a/doc/bug.template
+++ b/doc/bug.template
@@ -27,7 +27,7 @@ System Configuration
Operating System (example: Linux 2.0.26 ELF) :
- PostgreSQL version (example: PostgreSQL-7.0): PostgreSQL-7.0.1
+ PostgreSQL version (example: PostgreSQL-7.1): PostgreSQL-7.1
Compiler used (example: gcc 2.8.0) :
diff --git a/doc/src/FAQ.html b/doc/src/FAQ.html
index a71b00f90e3..e549bb98a45 100644
--- a/doc/src/FAQ.html
+++ b/doc/src/FAQ.html
@@ -137,7 +137,9 @@ am running? <BR>
large obj descriptor.</I> Why?<BR>
<A HREF="#4.22">4.22</A>) How do I create a column that will default to the
current time?<BR>
-<A HREF="#4.23">4.23</A>) Why are my subqueries using <CODE>IN</CODE> so slow?<BR>
+<A HREF="#4.23">4.23</A>) Why are my subqueries using <CODE>IN</CODE> so
+slow?<BR>
+<A HREF="#4.24">4.24</A>) How do I do an <i>outer</i> join?<BR>
<H2><CENTER>Extending PostgreSQL</CENTER></H2>
@@ -1206,6 +1208,22 @@ to:
</PRE></CODE>
We hope to fix this limitation in a future release.
+<H4><A NAME="4.24">4.24</A>) How do I do an <i>outer</i> join?<BR></H4><P>
+PostgreSQL does not support outer joins in the current release. They can
+be simulated using <small>UNION</small> and <small>NOT IN</small>. For
+example, when joining <i>tab1</i> and <i>tab2,</i> the following query
+does an <i>outer</i> join of the two tables:
+<PRE>
+ SELECT tab1.col1, tab2.col2
+ FROM tab1, tab2
+ WHERE tab1.col1 = tab2.col1
+ UNION ALL
+ SELECT tab1.col1, NULL
+ FROM tab1
+ WHERE tab1.col1 NOT IN (SELECT tab2.col1 FROM tab2)
+ ORDER BY tab1.col1
+</PRE>
+
<HR>
<H2><CENTER>Extending PostgreSQL</CENTER></H2><P>