db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag.Wan...@Sun.COM (Dag H. Wanvik)
Subject Re: [jira] Commented: (DERBY-716) Re-enable VTIs
Date Wed, 25 Apr 2007 23:05:56 GMT
"A B (JIRA)" <jira@apache.org> writes:

> Or as an alternate example, Derby currently supports the following:
>
>    ij> create table st as select * from
>           table (syscs_diag.space_table('T1')) s with no data;

Is this form documented anywhere? I can see it in the grammar, but I
can't find it anywhere in the docs. Omission?

Thanks, 
Dag

>
>    ij> insert into st select * from table (syscs_diag.space_table('T1')) s;

Mime
View raw message