On 08/15/2014 06:32 AM, hartzell@alerce.com wrote:
> This example, in section 5.8, Inheritance, suggests that someone thinks that
> New York the city is the capital of New York the state.
>
>> INSERT INTO cities (name, population, altitude, state)
> VALUES ('New York', NULL, NULL, 'NY');
>> We might hope that the data would somehow be routed to the capitals table,
> but this does not happen: INSERT always inserts into exactly the table
> specified. In some cases it is possible to redirect the insertion using a
> rule (see Chapter 38). However that does not help for the above case because
> the cities table does not contain the column state, and so the command will
> be rejected before the rule can be applied.
>
> The example would make more sense if the city were Albany.
Fixed, thanks.
- Heikki