blob: be3485553e4e495ccb062a75ba7c4e5e89c37cfe (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
/* postgres can not */
/* syntax version 1 */
use plato;
pragma OrderedColumns;
insert into @tmp
select * from Input order by subkey, key;
commit;
select * from @tmp order by subkey, key;
insert into @tmp with truncate
select key, value, subkey from Input order by subkey, key;
select * from @tmp order by subkey, key;
commit;
select * from @tmp order by subkey, key;
|
