Khushboo, that is exatcly what I do, but the content of the cell is cleared/emptied when editing a cell containing integer array data. The click & edit method works fine for other data types I have tried to edit.
I have a table defined as below. The answer_values column contains {1,2}, but when editing this cell, no popup is displayed as when editing answer_texts values. Instead, the edit view for answer_values is looking like the edit view for the stratification_id column, but with the cell content removed. When focus is moved to another cell, and no editing had occured, the display value of the answer_values is [null], i.e., the cell is empty.
---
CREATE TABLE public.stratification
(
stratification_id integer NOT NULL,
question_text character varying COLLATE pg_catalog."default" NOT NULL,
answer_texts character varying[] COLLATE pg_catalog."default" NOT NULL,
answer_values integer[] NOT NULL,
study integer NOT NULL,
CONSTRAINT stratification_id_pk PRIMARY KEY (stratification_id),
CONSTRAINT study_fk FOREIGN KEY (study)
REFERENCES public.study (study_id) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE NO ACTION
)
WITH (
OIDS = FALSE
)
TABLESPACE pg_default;
ALTER TABLE public.stratification
OWNER to postgres;