Re: SQL99 CREATE TABLE ... (LIKE parent_table)

On Tue, 2003-05-13 at 05:08, Hannu Krosing wrote:
> Tom Lane kirjutas E, 12.05.2003 kell 17:59:
> > Rod Taylor <rbt(at)rbt(dot)ca> writes:
> > > Quick patch to add the subject. Restructures all inheritance to consist
> > > of a few flags to indicate which structures we want to inherit
> >
> > I think overloading the inheritance mechanism to serve this purpose is a
> > bad idea.
>
> Are you sure that LIKE is not _supposed_ to be inheritable. I mean that
> changes done to the LIKE table should carry over to the table defined
> using LIKE:

> create table template( i int);
> create table instance(like template, t text);
> alter table template add column j int;
>
> and now instance should have columns i,j,t .

It is described as being replaced by the column definitions within the
new table, with no mention of connection to the parent table..

11.3, 6, d) "The <like clause> is effectively replaced by NCi, 1 (one)
<= i <= cnt"

--
Rod Taylor <rbt(at)rbt(dot)ca>

PGP Key: http://www.rbt.ca/rbtpub.asc