lsmacedo/rdm

Stop creating temporary table

Closed this issue · 0 comments

It is not necessary to create a temporary table. We can instead directly select values from a CTE.

Example:

with "cte__" as (
  values (1, 'one'),
  (2, 'two'),
  (3, 'three')
) s("id", "name")