How to set array element to null value

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.

Responses

Browse pgsql-general by date

  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

Browse pgsql-hackers by date

  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.