How to set array element to null value
| От | Brahmam Eswar |
|---|---|
| Тема | How to set array element to null value |
| Дата | |
| Msg-id | CA+wLFo03Wp6sg8xWp+FyCFKW+5ec3kJ8uVz_Y3akEKyF5nRO4w@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: How to set array element to null value
Re: How to set array element to null value Re: How to set array element to null value Re: How to set array element to null value Re: How to set array element to null value |
| Список | pgsql-general |
I'm trying to reset array element to null. but 3rd line of below snippet is giving the compilation error.
FOR indx_1 IN array_lower(X, 1)..array_upper(X, 1) LOOP
IF X[indx_1].REFERENCE_VALUE = 'ABC' THEN
X[indx_1].REFERENCE_VALUE:='';
END IF;
END LOOP;
Thanks & Regards,
Brahmeswara Rao J.
Brahmeswara Rao J.
В списке pgsql-general по дате отправления: