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.