I get an ambiguous column error for: user_id. query = """ SELECT table_1.user_id, table_1.method_id, FROM table_1 LEFT JOIN table_2 ON table_2.user_id = table_1.user ...
-- Cause: output-column names from RETURNS TABLE are in scope inside PL/pgSQL, -- so unqualified SELECT/ORDER BY names can collide with CTE columns.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results