| From: | Brahmam Eswar <brahmam1234(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | How to set array element to null value |
| Date: | 2018-07-09 09:58:45 |
| Message-ID: | CA+wLFo03Wp6sg8xWp+FyCFKW+5ec3kJ8uVz_Y3akEKyF5nRO4w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2018-07-09 10:26:46 | Re: How to set array element to null value |
| Previous Message | Łukasz Jarych | 2018-07-09 09:14:22 | Re: Cloning schemas |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2018-07-09 09:59:06 | Re: WAL prefetch |
| Previous Message | Arthur Zakirov | 2018-07-09 09:30:22 | Re: Let's remove DSM_IMPL_NONE. |