Postgresql – Why LATERAL not works with values?
It not make sense, a literal is not a valid column? SELECT x, y FROM (select 1 as x) t, LATERAL CAST(2 AS FLOAT) AS y; -- fine SELECT x, y FROM (select 1 as x) t, LATERAL 2.0 AS…
It not make sense, a literal is not a valid column? SELECT x, y FROM (select 1 as x) t, LATERAL CAST(2 AS FLOAT) AS y; -- fine SELECT x, y FROM (select 1 as x) t, LATERAL 2.0 AS…