| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
| Cc: | Philip Warner <pjw(at)rhyme(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Creating a zero-column table |
| Date: | 2002-12-13 14:59:39 |
| Message-ID: | 9375.1039791579@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> writes:
> 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.
Actually, in SQL92 11.17 <drop column definition> I find
3) C shall be a column of T and C shall not be the only column of
T.
SQL99 has the same rule. So they indeed prefer the no-drop wart to the
table-with-zero-columns wart. I have to disagree with that conclusion
though ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2002-12-13 15:08:54 | Re: Big 7.4 items |
| Previous Message | Robert Treat | 2002-12-13 14:44:26 | Re: Creating a zero-column table |