diff options
| author | Bruce Momjian <bruce@momjian.us> | 2001-11-07 17:27:36 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2001-11-07 17:27:36 +0000 |
| commit | a69833c5833cb62beff77248574c1beaadea0734 (patch) | |
| tree | 04c4925c87212e52a914cd8479b299b003155d7e | |
| parent | 75df678ffa88e3b043fc6574fb34b0e3ef5e5a9c (diff) | |
| download | postgresql-a69833c5833cb62beff77248574c1beaadea0734.tar.gz postgresql-a69833c5833cb62beff77248574c1beaadea0734.zip | |
Mention new =NULL change in Migration section.
| -rw-r--r-- | HISTORY | 11 |
1 files changed, 8 insertions, 3 deletions
@@ -37,9 +37,14 @@ several languages. Migration to 7.2 A dump/restore using pg_dump is required for those wishing to migrate - data from any previous release. The SELECT ... LIMIT 10,20 syntax will - be removed in 7.3. You should change your queries to use LIMIT 10 - OFFSET 20. Also, pg_hba.conf only loads on SIGHUP now. + data from any previous release. In this release, comparisons using "= + NULL" will always return false. Previous releases automatically + transformed this syntax to "IS NULL", which is the standards- + compliant way to do NULL comparisons. The old behavior can be + re-enabled using a postgresql.conf parameter. The SELECT ... LIMIT + #,# syntax will be removed in 7.3. You should change your queries to + use separate LIMIT and OFFSET clauses, e.g. LIMIT 10 OFFSET 20. Also, + pg_hba.conf now only loads on SIGHUP. |