Thread: AW: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL

> > > > I would propose that that anytime you do a SELECT * 
> from a base table
> > > > that you would get back the full rows from those sub tables.
> 
> Maybe SELECT ** FROM BASE would be more flexible as it leaves 
> the standard 
> SQL with its "standard" meaning ?

I like the idea of not messing with the traditional meaning of the *.
The Informix select * from table_with_subclasses also only returns 
the parent columns.

Of course I would also like that the default select * from table 
return all subclass rows.

Imho there is no real argument against extra syntax to select
all columns of subclasses though.

Andreas