blob: 92c8c6ec79edecf013bd7cb0589301563ad0c8ca (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
/* postgres can not */
use plato;
INSERT INTO Output1
SELECT
key as key,
"" as subkey,
"value:" || value as value
FROM Input
WHERE key < "100"
ORDER BY key;
INSERT INTO Output2
SELECT
key as key,
"" as subkey,
"value:" || value as value
FROM Input
WHERE key < "200"
ORDER BY key;
INSERT INTO Output1
SELECT
*
FROM Input
ORDER BY key;
INSERT INTO Output2
SELECT
*
FROM Input
ORDER BY key;
|
