WITH new_config AS (
SELECT JSONB_SET(json_config,
ARRAY['1','columnas', '2'],
JSONB_BUILD_OBJECT(
'desc' , 'Ubicación',
'table', 'sima.detalle_alumno',
'where' , 'nid_persona',
'enable', FALSE,
'columna', 'longitud'
),TRUE) as config
FROM sima.config_matricula
WHERE id_config = 3
)
UPDATE sima.config_matricula
SET json_config = (SELECT config FROM new_config)
WHERE id_config = 3;
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.