Variables in SQL
Jump to navigation
Jump to search
WITH vars as (
SELECT 'my-very-long-long-name' as foo,
112098237449803127134987 as num,
'{"hello":"there"}'::json as js
)
SELECT vars.foo, vars.js->'hello', num / 2
FROM vars;