clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2805438 fiddles created (40856 in the last week).

select jsonb_set(x, '{size}', to_jsonb(replace(x->>'size', 'W', '')::int)) from (values('{"size": "2W"}'::jsonb)) as t(x)
jsonb_set
{"size": 2}
 hidden batch(es)