Subquery that matches column with several ranges defined in table...

GROUP BY in Postgres - no equality for JSON data type?...

Join on id or null and get first result...

Can I do a LEFT JOIN LATERAL in Hive?...

Using stored procedure returning SETOF record in LEFT OUTER JOIN...

Create table from multiple calls to a function returning record...

Find most common elements in array with a group by...

Dynamically execute query using the output of another query...

plpgsql function that returns multiple columns gets called multiple times...