From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: How to set array element to null value |
Date: | 2018-07-09 10:29:44 |
Message-ID: | e1e65265-77f9-4c55-918e-d64d632cdc20@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Brahmam Eswar schrieb am 09.07.2018 um 11:58:
> 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;
What data type is X exactly? It looks like a composite record type.
(Also: an empty string '' is not the same as NULL)
From | Date | Subject | |
---|---|---|---|
Next Message | Łukasz Jarych | 2018-07-09 11:03:53 | Create event triger |
Previous Message | Pavel Stehule | 2018-07-09 10:26:46 | Re: How to set array element to null value |
From | Date | Subject | |
---|---|---|---|
Next Message | Nico Williams | 2018-07-09 10:47:56 | Re: How can we submit code patches that implement our (pending) patents? |
Previous Message | Pavel Stehule | 2018-07-09 10:26:46 | Re: How to set array element to null value |