blob: e499d334b0ffe3368eddf1a79305faa766bff331 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
|
PRAGMA DisableSimpleColumns;
/* postgres can not */
USE plato;
$data = (SELECT key as kk, subkey as sk, value || value as value FROM Input WHERE cast(key as uint32)/100 > 3);
--INSERT INTO Output
SELECT
value, key -- value is conflicted between Input and d sources
FROM Input JOIN $data as d ON Input.subkey = d.kk
;
|
