blob: f2ba42004611afa4027b11fd098951a7a58dc050 (
plain) (
blame)
1
2
3
4
5
6
7
|
/* syntax version 1 */
/* postgres can not */
$data = SELECT "a,b,c,d" AS a, "e,f,g,h" AS b, "x" AS c;
SELECT a,bb,c FROM $data FLATTEN BY (String::SplitToList(a, ",") as a, String::SplitToList(b, ",") as bb) WHERE bb != "h" ORDER BY a,bb;
|