Difference between revisions of "Variables in SQL"
Jump to navigation
Jump to search
(Created page with "<pre> WITH vars as ( SELECT 'my-very-long-long-name' as foo, 112098237449803127134987 as num, '{"hello":"there"}'::json as js ) SELECT vars.foo, vars.js->'...") |
(No difference)
|
Latest revision as of 11:46, 15 October 2025
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;