From 026a8510a375e63f6a9a6f7f86bc28b69c9be8fa Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Fri, 25 Feb 2005 00:32:15 +0000 Subject: Fix HTML markup and add NULL sorting item to existing NULL FAQ item. Greg Sabino Mullan --- doc/src/FAQ/FAQ.html | 45 ++++++++++++++++++++++++++++++++------------- 1 file changed, 32 insertions(+), 13 deletions(-) (limited to 'doc/src') diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index dd6be2928e9..74a653e09da 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: Mon Feb 14 23:35:09 EST 2005

+

Last updated: Thu Feb 24 19:32:04 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 @@ -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?

@@ -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 NULLIS 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?

-- cgit v1.2.3