7 lines
220 B
Text
7 lines
220 B
Text
|
CREATE OR REPLACE MACRO firsts(l) as (
|
||
|
|
WITH
|
||
|
|
t as (SELECT unnest(l) as x, generate_subscripts(l, 1) as index),
|
||
|
|
s as (SELECT x, min(index) as index FROM t GROUP BY x)
|
||
|
|
SELECT list(x ORDER BY index)
|
||
|
|
FROM s ) ;
|