Re: Creating a zero-column table

On Fri, 2002-12-13 at 03:43, Philip Warner wrote:
> At 02:56 AM 13/12/2002 -0500, Tom Lane wrote:
> >if it's not the only column in Amy's table, Beth can drop her type
> >and Amy's column along with it.
> 
> I keep forgetting PG's inheritance features. In a non-inheritance system, I 
> would vote for forcing a one column table to be dropped. For PG, I think 
> you are right.
> 

Just out of curiosity, do any of the SQL specs deal with 0 column
tables? I can't recall any dbms supporting a create table command that
didn't require at least 1 column.

Robert Treat