On Thu, 28 Mar 2024 at 04:34, Regina Obe <lr(at)pcorp(dot)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