Hi all.
Is there a way to inherit from a table with the LIKE construct and
also get its indexes along with contraints, DEFAULTs and NOT NULLs?
An example:
CREATE TABLE story_base (
flag BOOL NOT NULL DEFAULT TRUE,
starting TIMESTAMP NOT NULL DEFAULT '-INFINITY',
ending TIMESTAMP NOT NULL DEFAULT 'INFINTY'
);
CREATE INDEX i_story_base
ON story_base( flag,starting,ending );
CREATE TABLE atable (
sometext TEXT,
LIKE story_base INCLUDING DEFAULTS
);
I'd like atable to also "inherit" an index like the one defined for
story_base.
Any hint?
--
Reg me, please!