Garak: Created page with "

 WITH vars as (   SELECT 'my-very-long-long-name' as foo,          112098237449803127134987 as num,          '{"hello":"there"}'::json as js ) SELECT vars.foo, vars.js->'..."

2025-10-15T11:46:11Z

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->'..."

New page

<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->'hello', num / 2
FROM vars;
</pre>

Variables in SQL - Revision history

Garak: Created page with "
WITH vars as ( SELECT 'my-very-long-long-name' as foo, 112098237449803127134987 as num, '{"hello":"there"}'::json as js ) SELECT vars.foo, vars.js->'..."