diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-02-25 00:32:55 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-02-25 00:32:55 +0000 |
| commit | 3debf968ef2c5d4a85842a2fe78bbb28a343ba0f (patch) | |
| tree | 63fa155d5cc49fbd28921b34ea0db418d8f7f71f | |
| parent | 026a8510a375e63f6a9a6f7f86bc28b69c9be8fa (diff) | |
| download | postgresql-3debf968ef2c5d4a85842a2fe78bbb28a343ba0f.tar.gz postgresql-3debf968ef2c5d4a85842a2fe78bbb28a343ba0f.zip | |
Fix markup.
| -rw-r--r-- | doc/FAQ | 10 | ||||
| -rw-r--r-- | doc/src/FAQ/FAQ.html | 4 |
2 files changed, 7 insertions, 7 deletions
@@ -1,7 +1,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Thu Feb 24 19:32:04 EST 2005 + Last updated: Thu Feb 24 19:33:07 EST 2005 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -645,10 +645,10 @@ 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: + 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) diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index 74a653e09da..d328aa639a5 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -10,7 +10,7 @@ alink="#0000ff"> <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1> - <P>Last updated: Thu Feb 24 19:32:04 EST 2005</P> + <P>Last updated: Thu Feb 24 19:33:07 EST 2005</P> <P>Current maintainer: Bruce Momjian (<A href= "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>) @@ -828,7 +828,7 @@ table?</TD><TD>unlimited</TD></TR> WHERE col IS NULL; </PRE> - <P>To sort by the <SMALL>NULL</SMALL status, use the <SMALL>IS NULL</SMALL> + <P>To sort by the <SMALL>NULL</SMALL> status, use the <SMALL>IS NULL</SMALL> and <SMALL>IS NOT NULL</SMALL> modifiers in your <SMALL>WHERE</SMALL> clause. Things that are <I>true</I> will sort higher than things that are <I>false</I>, so the following will put NULL entries at the top of the resulting list:</P> |