[EMAIL PROTECTED] create view v as select 1::int;
CREATE VIEW
[EMAIL PROTECTED] select * from v;
 int4
------
    1
(1 row)
[EMAIL PROTECTED] create table t ( like v);
ERROR:  inherited relation "v" is not a table



Why? Is there any logical reason for this? View is just a table with
some rule ON SELECT...



-- 
Filip Rembiałkowski

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Reply via email to