sql - Error malformed array literal: must introduce explicitly-specified array dimensions

Question

I have next query:

UPDATE public.user_item
    set instructions = concat('[', array_to_string(instructions::Text[], '", "')', ']')
    where instructions is not null;

It fails with error:

ERROR:  malformed array literal: "["ERYTHRITOL, STEVIA LEAF EXTRACT, NATURAL FLAVORS."]"
DETAIL:  "[" must introduce explicitly-specified array dimensions.

type of field 'instructions' is text

question from:https://stackoverflow.com/questions/65843521/error-malformed-array-literal-must-introduce-explicitly-specified-array-dimensi

Answer 1

Waitting for answers