Index: FAQ.html =================================================================== RCS file: /cvsroot/pgsql/doc/src/FAQ/FAQ.html,v retrieving revision 1.288 retrieving revision 1.291 diff -c -c -r1.288 -r1.291 *** FAQ.html 15 Feb 2005 04:35:37 -0000 1.288 --- FAQ.html 25 Feb 2005 00:45:30 -0000 1.291 *************** *** 10,16 **** alink="#0000ff">
Last updated: Mon Feb 14 23:35:09 EST 2005
Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) --- 10,16 ---- alink="#0000ff">
Last updated: Thu Feb 24 19:45:40 EST 2005
Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
***************
*** 85,91 ****
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?
4.10) What is the difference between the
various character types?
4.11.1) How do I create a
--- 85,92 ----
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? 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,168 ****
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
Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a --- 163,169 ----
PostgreSQL Data Base Management System
Portions Copyright (c) 1996-2005, PostgreSQL Global Development Group ! 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,212 ****
The primary anonymous ftp site for PostgreSQL is ftp://ftp.PostgreSQL.org/pub. For mirror sites, see our main web site.
The primary anonymous ftp site for PostgreSQL is ftp://ftp.PostgreSQL.org/pub/. For mirror sites, see our main web site.
A list of commercial support companies is available at http://techdocs.postg ! resql.org/companies.php.
A list of commercial support companies is available at ! http://techdocs.postgresql.org/companies.php.
Also check out our ftp site ftp://ftp.PostgreSQL.org/pub to see if there is a more recent PostgreSQL version.
Also check out our ftp site ftp://ftp.PostgreSQL.org/pub/ to see if there is a more recent PostgreSQL version.
For complex cases, many use the Perl and CGI.pm or mod_perl.
For complex cases, many use the Perl and DBD::Pg with CGI.pm or ! mod_perl.
You test the column with IS NULL and IS NOT NULL.
--- 816,844 ----4.9) In a query, how do I detect if a field ! 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?