| Subject | Re: [firebird-support] "CREATE TABLE AS SELECT ... " syntax |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-05-22T00:40:38Z |
At 07:01 PM 21/05/2004 +0000, you wrote:
not true.
except through the EXECUTE STATEMENT construct. However, you *can* write a
selectable SP that creates a virtual table from a select statement, of
course (as you seem to have done here, already...)
/heLen
>Hi,No.
>
>Has "CREATE TABLE AS SELECT ... " been implemented in FB 1.5?
>Can it be used with Views "CREATE TABLE AS SELECT * FROM SOMEVIEW" ?No. You can CREATE VIEW AS SELECT....FROM SOMETABLE, but the reverse is
not true.
>Can it be used with Stored Procedures "CREATE TABLE AS SELECT * FROMNo; in any case, stored procedures don't allow any sort of DDL statement,
>PAIDINVOICES('20040101','20040530')" ?
except through the EXECUTE STATEMENT construct. However, you *can* write a
selectable SP that creates a virtual table from a select statement, of
course (as you seem to have done here, already...)
/heLen