From 4a68e59418695a64110f2bd50ad067b436a9db18 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Fri, 25 Feb 2005 00:33:45 +0000 Subject: Backpatch FAQ to 8.0.X. --- doc/src/FAQ/FAQ.html | 57 ++++++++++++++++++++++++++++++++++------------------ 1 file changed, 38 insertions(+), 19 deletions(-) (limited to 'doc/src') diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index c77ef9a36bb..d328aa639a5 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -10,7 +10,7 @@ alink="#0000ff">

Frequently Asked Questions (FAQ) for PostgreSQL

-

Last updated: Wed Feb 2 12:44:03 EST 2005

+

Last updated: Thu Feb 24 19:33:07 EST 2005

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -85,7 +85,8 @@ searches and case-insensitive regular expression searches? How do I use an index for case-insensitive searches?
4.9) In a query, how do I detect if a field - is NULL?
+ is NULL? How can I sort on whether a field is + NULL or not?
4.10) What is the difference between the various character types?
4.11.1) How do I create a @@ -112,8 +113,8 @@ databases?
4.19) How do I return multiple rows or columns from a function?
- 4.20) Why can't I reliably create/drop - temporary tables in PL/PgSQL functions?
+ 4.20) Why do I get "missing oid" errors when + accessing temporary tables in PL/PgSQL functions?
4.21) What encryption options are available?
@@ -162,7 +163,7 @@

PostgreSQL Data Base Management System

Portions Copyright (c) 1996-2005, PostgreSQL Global Development Group - Portions Copyright (c) 1994-6 Regents of the University of California

+ Portions Copyright (c) 1994-1996 Regents of the University of California

Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a @@ -206,7 +207,7 @@

1.4) Where can I get PostgreSQL?

The primary anonymous ftp site for PostgreSQL is ftp://ftp.PostgreSQL.org/pub. + "ftp://ftp.PostgreSQL.org/pub/">ftp://ftp.PostgreSQL.org/pub/. For mirror sites, see our main web site.

1.5) Where can I get support?

@@ -225,8 +226,8 @@ (#postgresqlfr). There is also a PostgreSQL channel on EFNet.

A list of commercial support companies is available at http://techdocs.postg - resql.org/companies.php.

+ "http://techdocs.postgresql.org/companies.php"> + http://techdocs.postgresql.org/companies.php.

1.6) How do I submit a bug report?

@@ -235,7 +236,7 @@ http://www.postgresql.org/support/submitbug.

Also check out our ftp site ftp://ftp.PostgreSQL.org/pub to + "ftp://ftp.PostgreSQL.org/pub/">ftp://ftp.PostgreSQL.org/pub/ to see if there is a more recent PostgreSQL version.

1.7) What is the latest release?

@@ -253,7 +254,7 @@

There are two PostgreSQL books available online at http://www.PostgreSQL.org/docs/awbook.html + "http://www.postgresql.org/docs/books/awbook.html">http://www.postgresql.org/docs/books/awbook.html and http://www.commandprompt.com/ppbook/. There is a list of PostgreSQL books available for purchase at SQL?

The PostgreSQL book at http://www.PostgreSQL.org/docs/awbook.html + "http://www.postgresql.org/docs/books/awbook.html">http://www.postgresql.org/docs/books/awbook.html teaches SQL. There is another PostgreSQL book at http://www.commandprompt.com/ppbook. @@ -411,7 +412,8 @@ href="http://www.php.net">http://www.php.net) is an excellent interface.

-

For complex cases, many use the Perl and CGI.pm or mod_perl.

+

For complex cases, many use the Perl DBD::Pg with CGI.pm or + mod_perl.

2.3) Does PostgreSQL have a graphical user interface?

@@ -421,10 +423,9 @@ href="http://www.pgadmin.org">http://www.pgadmin.org, PgAccess http://www.pgaccess.org), RHDB Admin (http://sources.redhat.com/rhd - b/ ), TORA (http://www.globecom.net/tora/, - partly commercial), and Rekall (http://sources.redhat.com/rhdb/ + ), TORA ( + http://www.globecom.net/tora/, partly commercial), and Rekall ( http://www.rekallrevealed.org/). There is also PhpPgAdmin ( @@ -815,11 +816,29 @@ table?unlimited

4.9) In a query, how do I detect if a field - is NULL?

+ is NULL? How can I sort on whether a field is + NULL or not?

You test the column with IS NULL and IS NOT NULL.

+
+   SELECT *
+   FROM tab
+   WHERE col IS NULL;
+
+ +

To sort by the NULL status, use the IS NULL + and IS NOT NULL modifiers in your WHERE clause. + Things that are true will sort higher than things that are false, + so the following will put NULL entries at the top of the resulting list:

+ +
+   SELECT *
+   FROM tab
+   ORDER BY (col IS NOT NULL)
+
+

4.10) What is the difference between the various character types?

@@ -1039,8 +1058,8 @@ length http://techdocs.postgresql.org/guides/SetReturningFunctions. -

4.20) Why can't I reliably create/drop - temporary tables in PL/PgSQL functions?

+

4.20) Why do I get "missing oid" errors when + accessing temporary tables in PL/PgSQL functions?

PL/PgSQL caches function scripts, and an unfortunate side effect is that if a PL/PgSQL function accesses a temporary table, and that -- cgit v1.2.3