blob: 4c9c4bd612d15c461ccba0a5b1453245f90d6e92 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
PRAGMA DisableSimpleColumns;
/* postgres can not */
USE plato;
$data = (SELECT key as kk, subkey as sk, value FROM Input WHERE cast(key as uint32)/100 < 5);
--INSERT INTO Output
SELECT
*
WITHOUT
d.value
FROM Input JOIN $data as d ON Input.subkey = cast(cast(d.kk as uint32)/100 as string)
ORDER BY key
;
|
