blob: f1f3423811d267bb28732542c2352da8634008f5 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
|
/* postgres can not */
use plato;
pragma DisableSimpleColumns;
discard select 1;
discard select * from Input;
discard select * from Input where key<"foo";
discard select * from Input as a join Input as b using(key);
discard select sum(length(value)), key, subkey from Input group by rollup(key,subkey) order by key, subkey;
discard select * from (select key || "a" || "b" as key from Input) as a join (select key || "ab" as key from Input) as b using(key);
|
