blob: b495924f3d42defc8084831c11f3aba10bc2fb42 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
/* postgres can not */
/* syntax version 1 */
use plato;
pragma OrderedColumns;
select * from Input order by subkey;
select * without key from Input order by subkey;
select a.* from Input as a order by a.subkey;
select a.* without key from Input as a order by a.subkey;
select 1 as z, 2 as x, a.* from Input as a order by a.subkey;
select 1 as z, 2 as x, a.* without key from Input as a order by a.subkey;
select 1 as c, 2 as b, 3 as a;
|