This feature will appear in 7.2:
test=> create view aaa (x) as select relname from pg_class;
CREATE
test=> select * from aaa;
x
-
pg_type
pg_attribute
> > My problem is tha
Bruce Momjian <[EMAIL PROTECTED]> writes:
> This feature will appear in 7.2:
> test=> create view aaa (x) as select relname from pg_class;
It's already there in 7.1.
IIRC, the real problem was that Jefim was trying to use a reserved word
as a column name.
regards,
> My problem is that the ErWin generates the following syntax
> create view [view name] ( [col1] , [col2] ) as select [s1], [s2] from
> [table name];
> and as far as I know this is SQL92.
(checks spec...) You're right, SQL92 does require this syntax. Okay,
I'll put it on the to-do list.
Jefim Matskin <[EMAIL PROTECTED]> writes:
> The follwoing statement does not work:
> create view testview (primary) as select 'true';
> The error I get is:
> ERROR: parser: parse error at or near "primary"
This is not a bug --- the syntax of CREATE VIEW has no provision for a
column name lis
The follwoing statement does not work:
create view testview (primary) as select 'true';
The error I get is:
ERROR: parser: parse error at or near "primary"
Using PostgerSQL 7.1 on linux redhat kernel 2.2.19 intel.
> Jefim Matskin
>
>
>
---(end of broadcast)-
