Re: DEFAULT Constraint based on table type?

On Mon, 2005-11-28 at 14:22 -0600, Announce wrote:
> Lets say I have the following tables.
>
> CREATE TABLE animals(id primary key, name varchar, type varchar);
> CREATE TABLE dogs (breed varchar) INHERITS (animals);
> CREATE TABLE birds (bool hasFeathers) INHERITS (animals);

r=# alter table birds alter type set default 'Bird';
ALTER TABLE
r=# \d birds
Table "public.birds"
Column | Type | Modifiers
-------------+-------------------+-----------------------------------
id | integer | not null
name | character varying |
type | character varying | default 'Bird'::character varying
hasfeathers | boolean |
Inherits: animals

r=# \d animals
Table "public.animals"
Column | Type | Modifiers
--------+-------------------+-----------
id | integer | not null
name | character varying |
type | character varying |
Indexes:
"animals_pkey" PRIMARY KEY, btree (id)

--