| 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 |