blob: 5367b6913b94c5985595d4d5cd10a752731892c1 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
/* postgres can not */
/* syntax version 1 */
use plato;
pragma OrderedColumns;
insert into Input
select key, subkey, value from Input;
commit;
select * from Input order by subkey, key;
insert into Output
select * from Input order by subkey, key;
commit;
select * from Output order by subkey, key;
insert into Output with truncate
select key,value,subkey from Input order by subkey, key;
select * from Output order by subkey, key;
commit;
select * from Output order by subkey, key;
|
