RosettaCodeData/Task/List-comprehensions/DuckDB/list-comprehensions-3.duckdb
2025-08-11 18:05:26 -07:00

4 lines
171 B
Text

create or replace function list_triples(n) as (
[ xyz FOR xyz IN (select array_agg([x,y,z] order by x) FROM xyz(n))
IF xyz[1]**2 + xyz[2]**2 = xyz[3]**2 ]
);