This query might seem simple, but it can lead to unexpected results if the `salary` column contains NULL values. The condition `salary > 100000` will evaluate to `UNKNOWN` for NULL salaries, and ...
-- 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