On Thu, 28 Mar 2024 at 04:34, Regina Obe <l...@pcorp.us> wrote: > CREATE TABLE edge_data AS > SELECT i AS edge_id, i + 1 AS start_node, i + 2 As end_node > FROM generate_series(1,10) AS i; > > WITH edge AS ( > SELECT start_node, end_node > FROM edge_data > WHERE edge_id = 1 > ) > SELECT start_node id FROM edge UNION > SELECT end_node FROM edge;
As of d5d2205c8, this query should work as expected. Thank you for letting us know about this. David
