Alphabetical index

Firebird Documentation Index → Firebird Null Guide → Alphabetical index

Firebird Home

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, Using domains to add a non-nullable field

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

remove, Removing a CHECK constraint
via domain, remove from column, Removing a domain-based CHECK constraint

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, Removing a NOT NULL constraint

via domain, Using domains to add a non-nullable field

add, Making an existing column NOT NULL

via domain, remove from column, Removing a domain-based NOT NULL constraint

NOT operator, Boolean operations

NULL, What is NULL?

and GROUP BY, The GROUP BY clause

as a default, NULL as a default state

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, Using domains to add a non-nullable field

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 Documentation Index → Firebird Null Guide → Alphabetical index