select into...

[Ruslan Zasukhin]

On 3/5/12 5:25 PM, "George Parkinson" <george at microtherapy.ca> wrote:

Hi George,

> hello,
> any plans to support 'SELECT INTO'?

I think we have this syntax or its analog ..

Checking wiki ...

http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:
reference:sqlgrammar:5.0#queries

table_definition
    :    CREATE [OR REPLACE] [ {GLOBAL | LOCAL} TEMPORARY] {[RAM] |
[SYSTEM]}
         TABLE [IF NOT EXISTS] table_name
         { table_element_list [ON COMMIT {DELETE | PRESERVE} ROWS ]
         | AS direct_select_statement_multiple_rows
         } 


So you can do 
    CREATE  [RAM TEMPORARY] TABLE  zzz
    as SELECT ... 




-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]