123456789 |
- /* 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);
|