SQL? – work with data from the clob::JSON column – issue SOLVED
ANSWER IS: — SELECT id, person_id, validity_date FROM public.product WHERE validity_date IS NULL;— UPDATE public.product SET validity_date = to_timestamp(clob::json->’validityDate’::text #>> ‘{}’, ‘yyyy-MM-dd’)::timestamp WHERE validity_date IS NULL; — SELECT id, person_id, validity_date FROM public.product WHERE person_id IS NULL;— UPDATE public.product SET person_id = clob::json->’personId’::text #>> ‘{}’ WHERE person_id IS NULL; —– Update sql request— SELECT id, …
SQL? – work with data from the clob::JSON column – issue SOLVED Read More »