....................................................................................50 5.3.2. Not-Null Constraints....................................................................................52 Mapping................................................................................1093 43.3.2. Null, None............................................................................................ Configuration.............................................................................2785 F.25.6.2. NULL Handling ........................................................................2786 F.25.6.3. Security

....................................................................................55 5.3.2. Not-Null Constraints...................................................................................... .....................................................................................1161 43.3.2. Null, None............................................................................................ ...................................................................................2955 F.25.6.2. NULL Handling ...............................................................................2956 F.25

....................................................................................50 5.3.2. Not-Null Constraints....................................................................................52 Mapping................................................................................1059 42.3.2. Null, None............................................................................................ Configuration.............................................................................2627 F.25.6.2. NULL Handling ........................................................................2627 F.25.6.3. Security

....................................................................................55 5.3.2. Not-Null Constraints...................................................................................... .....................................................................................1126 42.3.2. Null, None............................................................................................ ...................................................................................2794 F.25.6.2. NULL Handling ...............................................................................2794 F.25

of the left table. When outputting a left-table row for which there is no right-table match, empty (null) values are substituted for the right-table columns. Exercise: There are also right outer joins real, elevation int -- (in ft) ); CREATE TABLE capitals ( state char(2) UNIQUE NOT NULL ) INHERITS (cities); In this case, a row of capitals inherits all columns (name, population, and ................................................................................... 65 5.3.2. Not-Null Constraints ................................................................................. 68 5

of the left table. When outputting a left-table row for which there is no right-table match, empty (null) values are substituted for the right-table columns. 12 The SQL Language Exercise: There are real, elevation int -- (in ft) ); CREATE TABLE capitals ( state char(2) UNIQUE NOT NULL ) INHERITS (cities); In this case, a row of capitals inherits all columns (name, population, and Constraints ............................................................................... 61 5.3.2. Not-Null Constraints ............................................................................ 63 5.3.3

of the left table. When outputting a left-table row for which there is no right-table match, empty (null) values are substituted for the right-table columns. Exercise: There are also right outer joins real, elevation int -- (in ft) ); CREATE TABLE capitals ( state char(2) UNIQUE NOT NULL ) INHERITS (cities); In this case, a row of capitals inherits all columns (name, population, and ................................................................................... 59 5.3.2. Not-Null Constraints ................................................................................. 61 5

of the left table. When outputting a left-table row for which there is no right-table match, empty (null) values are substituted for the right-table columns. Exercise: There are also right outer joins real, elevation int -- (in ft) ); CREATE TABLE capitals ( state char(2) UNIQUE NOT NULL ) INHERITS (cities); In this case, a row of capitals inherits all columns (name, population, and Constraints ............................................................................... 56 5.3.2. Not-Null Constraints ............................................................................ 58 5.3.3

....................................................................................50 5.3.2. Not-Null Constraints....................................................................................52 Mapping................................................................................1022 42.3.2. Null, None............................................................................................ Configuration.............................................................................2496 F.28.6.2. NULL Handling ........................................................................2497 F.28.6.3. Security

....................................................................................55 5.3.2. Not-Null Constraints...................................................................................... .....................................................................................1084 42.3.2. Null, None............................................................................................ ...................................................................................2655 F.28.6.2. NULL Handling ...............................................................................2656 F.28