Firebird Docset
→
Firebird Database Docs
→
Firebird Null Guide
→ Alphabetical index
Alphabetical index
A
Adding CHECKed columns,
Adding a CHECKed column
Adding non-nullable columns,
Adding a non-nullable field to a populated table
Adding NOT NULL columns,
Adding a NOT NULL field
using domains,
Adding a non-nullable field using domains
Aggregate functions,
Aggregate functions
GROUP BY,
The GROUP BY clause
HAVING,
The HAVING clause
ALL,
The ANY, SOME and ALL quantifiers
bug with indexed subselect,
ALL with indexed subselect
results,
Result values
Altering tables,
Altering populated tables
AND operator,
Boolean operations
ANY,
The ANY, SOME and ALL quantifiers
bug with indexed subselect,
IN, =ANY and =SOME with indexed subselect
results,
Result values
Assigning NULL,
Assigning NULL
AVG,
Aggregate functions
B
Backup,
Adding a NOT NULL field
BETWEEN,
Mathematical and string operations
Boolean operations,
Boolean operations
Bugs list,
NULL-related bugs in Firebird
other bugs,
Other bugs
server-crashers,
Bugs that crash the server
C
CASE,
CASE statements
CHECK constraints,
IN() in CHECK constraints
,
CHECK constraints
COALESCE,
The COALESCE function
Comparison operations,
Mathematical and string operations
Conjunctions,
Boolean operations
CONTAINING,
Mathematical and string operations
Conversions,
Converting to and from NULL
from a value to NULL,
Converting values to NULL
NULLIF internal function,
Firebird 1.5 and up: the NULLIF function
NULLIF UDFs,
Firebird 1.0: the *nullif UDFs
from NULL to a value,
Substituting NULL with a value
COALESCE,
The COALESCE function
NVL functions,
Firebird 1.0: the *NVL functions
unwanted,
NULL <–> non-NULL conversions you didn't ask for
prepare for,
Being prepared for undesired conversions
COUNT,
Aggregate functions
D
Descriptors,
Descriptors
Directives,
FIRST, SKIP and ROWS
Disjunctions,
Boolean operations
DISTINCT
SELECT DISTINCT,
Sorts
,
SELECT DISTINCT
,
SELECT DISTINCT with wrong NULLS FIRST|LAST ordering
testing distinctness,
Testing DISTINCTness (Firebird 2+)
,
Firebird 2.0 and up
E
Equality tests,
Equality tests
in Firebird 1.*,
Earlier Firebird versions
in Firebird 2+,
Firebird 2.0 and up
summary,
Summary of (in)equality tests
EXISTS,
EXISTS
F
False,
Boolean operations
beating NULL,
Boolean operations
FIRST,
FIRST, SKIP and ROWS
FOR loops,
FOR loops
Foreign keys,
Foreign keys
FSQL,
FSQL
Functions
aggregate,
Aggregate functions
GROUP BY,
The GROUP BY clause
internal,
Internal functions
G
gbak,
Adding a NOT NULL field
-n switch,
Ensuring the validity of your data
GROUP BY,
The GROUP BY clause
H
HAVING,
The HAVING clause
I
IF statements,
IF statements
IN
bug with indexed subselect,
IN, =ANY and =SOME with indexed subselect
IN predicate,
The IN predicate
in CHECK constraints,
IN() in CHECK constraints
results,
IN() results
Indices,
Keys and unique indices
unique,
Unique keys and indices
Internal functions,
Internal functions
IS [NOT] DISTINCT FROM,
Testing DISTINCTness (Firebird 2+)
,
Firebird 2.0 and up
IS [NOT] NULL,
Testing for NULL
J
JOIN,
Summary of (in)equality tests
K
Keys,
Keys and unique indices
,
Foreign keys
foreign,
Foreign keys
primary,
Primary keys
unique,
Unique keys and indices
L
LIKE,
Mathematical and string operations
LIST,
Aggregate functions
M
Mathematical operations,
Mathematical and string operations
MAX,
Aggregate functions
MIN,
Aggregate functions
N
NOT NULL,
Disallowing NULL
direct,
Adding a NOT NULL field
remove,
Making non-nullable columns nullable again
via domain,
Adding a non-nullable field using domains
add,
Making an existing column NOT NULL
remove,
Making non-nullable columns nullable again
NOT operator,
Boolean operations
NULL,
What is NULL?
and GROUP BY,
The GROUP BY clause
assign,
Assigning NULL
bugs,
NULL-related bugs in Firebird
conversions from,
Substituting NULL with a value
conversions to,
Converting values to NULL
conversions to/from,
Converting to and from NULL
disallow,
Disallowing NULL
falsely reported as 0,
False reporting of NULLs as zeroes
in a nutshell,
Summary
in aggregate functions,
Aggregate functions
in boolean operations,
Boolean operations
in CHECK constraints,
CHECK constraints
in conjunctions,
Boolean operations
in disjunctions,
Boolean operations
in foreign keys,
Foreign keys
in IF statements,
IF statements
in indices,
Keys and unique indices
in internal functions,
Internal functions
in JOINs,
Summary of (in)equality tests
in keys,
Keys and unique indices
in NOT NULL columns,
Adding a NOT NULL field
in operations,
NULL in operations
in primary keys,
Primary keys
in searches,
Searches
in sorts,
Sorts
in UDFs,
User-Defined Functions (UDFs)
in unique keys and indices,
Unique keys and indices
literal,
The NULL literal
NULL keyword in UDFs,
Improvements in Firebird 2
test for,
Testing for NULL
in practice,
Testing for NULL and equality in practice
What is it?,
What is NULL?
with IN(),
The IN predicate
NULL keyword in UDFs,
Improvements in Firebird 2
NULLIF internal function,
Firebird 1.5 and up: the NULLIF function
NULLIF UDFs,
Firebird 1.0: the *nullif UDFs
NULLS FIRST,
Sorts
NULLS LAST,
Sorts
NVL functions,
Firebird 1.0: the *NVL functions
O
OR operator,
Boolean operations
ORDER BY,
Sorts
Ordering,
Sorts
P
Predicates,
Predicates
ANY, SOME and ALL,
The ANY, SOME and ALL quantifiers
results,
Result values
EXISTS,
EXISTS
IN,
The IN predicate
results,
IN() results
SINGULAR,
SINGULAR
Primary keys,
Primary keys
R
Restoring
problem with NULLs,
Adding a NOT NULL field
solution,
Ensuring the validity of your data
ROWS,
FIRST, SKIP and ROWS
S
Searches,
Searches
SELECT DISTINCT,
Sorts
,
SELECT DISTINCT
,
SELECT DISTINCT with wrong NULLS FIRST|LAST ordering
SINGULAR,
SINGULAR
SKIP,
FIRST, SKIP and ROWS
SOME,
The ANY, SOME and ALL quantifiers
bug with indexed subselect,
IN, =ANY and =SOME with indexed subselect
results,
Result values
Sorting,
Sorts
STARTING WITH,
Mathematical and string operations
String operations,
Mathematical and string operations
SUM,
Aggregate functions
Summary,
Summary
T
Tables
add CHECK to columns,
Adding a CHECK constraint to an existing column
add CHECKed columns,
Adding a CHECKed column
add non-nullable columns,
Adding a non-nullable field to a populated table
add NOT NULL columns,
Adding a NOT NULL field
using domains,
Adding a non-nullable field using domains
altering,
Altering populated tables
make columns non-nullable,
Making existing columns non-nullable
make columns NOT NULL,
Making an existing column NOT NULL
make columns nullable,
Making non-nullable columns nullable again
Testing for NULL,
Testing for NULL
in practice,
Testing for NULL and equality in practice
True,
Boolean operations
beating NULL,
Boolean operations
U
UDFs,
User-Defined Functions (UDFs)
by descriptor,
Descriptors
links,
More on UDFs
NULLIF functions,
Firebird 1.0: the *nullif UDFs
NVL functions,
Firebird 1.0: the *NVL functions
unwanted conversions,
NULL <–> non-NULL conversions you didn't ask for
prepare for,
Being prepared for undesired conversions
with NULL keyword,
Improvements in Firebird 2
Unique indices,
Unique keys and indices
Unique keys,
Unique keys and indices
W
WHERE,
Searches
WHILE loops,
WHILE loops
Firebird Docset
→
Firebird Database Docs
→
Firebird Null Guide
→ Alphabetical index