meta data for this page
B: Document history
The exact file history is recorded in the manual module in our CVS tree; see https://sourceforge.net/cvs/?group_id=9028.
Revision history
0.1 | 8 Apr 2005 | PV | First edition. |
0.2 | 15 Apr 2005 | PV | Mentioned that Fb 2.0 legalises A = NULL” comparisons. Changed text in “Testing if something is NULL”. Slightly altered “Dealing with NULLs” section. |
1.0 | 24 Jan 2007 | PV | This is a major update, with so much new material added that the document has grown to around 4 times its former size. In addition, much of the existing text has been reorganised and thoroughly reworked. It's not feasible to give a summary of all the changes here. Consider this a new guide with 15–25% old material. The most important additions are: |
* NULL literals | |||
* IS [NOT] DISTINCT FROM | |||
* Internal functions and directives | |||
* Predicates: IN, ANY, SOME, ALL, EXISTS, SINGULAR | |||
* Searches (WHERE) | |||
* Sorts (ORDER BY) | |||
* GROUP BY and HAVING | |||
* CASE, WHILE and FOR | |||
* Keys and indices | |||
* CHECK constraints | |||
* SELECT DISTINCT | |||
* Converting values to NULL with NULLIF | |||
* Altering populated tables | |||
* Bugs list | |||
* Alphabetical index | |||
1.0.1 | 26 Jan 2007 | PV | Making non-nullable columns nullable again: Provisory fix of error regarding removal of NOT NULL constraints. |