The first SQL command throws an error whereas the second one runs fine:
edb=# create schema s1 authorization u1
edb-# create table t1() create view v1 as select * from t1;
ERROR: view must have at least one column
edb=#
edb=# create schema s1 authorization u1
edb-# create table t1( c1 int ) create view v1 as select * from t1;
CREATE SCHEMA
edb=#
I know the ERROR seems obvious, but then if we allow zero-column tables,
then why not zero-column views?
Or should the question be, why do we allow zero-column tables? (is
inheritance the only reason?)
Can someone provide some explanation for this behaviour?
Best regards,
--
gurjeet[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ gmail | hotmail | yahoo }.com
17°29'34.37"N 78°30'59.76"E