Firebird DocsetFirebird Database DocsFirebird Null Guide → Alphabetical index
Firebird home Firebird home Prev: License noticeHome: Firebird DocsetUp: Firebird Null Guide

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

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

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

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

W

WHERE, Searches
WHILE loops, WHILE loops
Prev: License noticeHome: Firebird DocsetUp: Firebird Null Guide
Firebird DocsetFirebird Database DocsFirebird Null Guide → Alphabetical index