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 ............................................................................... 61 5.4.2. Not-Null Constraints ............................................................................ 63 5.4.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 ................................................................................... 65 5.4.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. 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 ............................................................................... 64 5.5.2. Not-Null Constraints ............................................................................ 66 5.5.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 ................................................................................... 69 5.5.2. Not-Null Constraints ................................................................................. 71 5

....................................................................................42 5.3.2. Not-Null Constraints...................................................................................... 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 and modulo + - left addition, subtraction IS IS TRUE, IS FALSE, IS UNKNOWN, IS NULL ISNULL test for null NOTNULL test for not null (any other) left all other native and user-defined operators IN set membership

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 ............................................................................... 62 5.4.2. Not-Null Constraints ............................................................................ 65 5.4.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 ................................................................................... 67 5.4.2. Not-Null Constraints ................................................................................. 69 5

....................................................................................42 5.3.2. Not-Null Constraints...................................................................................... 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. 11 Chapter 2. The SQL Language Exercise: There modulo + - left addition, subtraction IS IS TRUE, IS FALSE, IS UNKNOWN, IS NULL ISNULL test for null NOTNULL test for not null (any other) left all other native and user-defined operators IN set membership

....................................................................................40 5.3.2. Not-Null Constraints....................................................................................42 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 and modulo + - left addition, subtraction IS IS TRUE, IS FALSE, IS UNKNOWN, IS NULL ISNULL test for null NOTNULL test for not null (any other) left all other native and user-defined operators IN set membership

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.4.2. Not-Null Constraints ............................................................................ 63 5.4.3