Feedback-ID: i76984098:Fastmail
Message-ID: <fb0589a1-701f-4447-9c49-7001e14e09a5@aklaver.com>
Date: Sat, 7 Mar 2026 07:44:30 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: How to properly use TRIM()?
To: Igor Korot <ikorot01@gmail.com>,
 "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <CA+FnnTxGOqF1DN4e70KXRJakuPV_V7_vGonQTX4eEOEE92PCKw@mail.gmail.com>
 <CAKFQuwakY0c3x=2o=gQ6Cr7jQ=DgE_snL1cHf8Oj+irO1fmjEQ@mail.gmail.com>
 <CA+FnnTzq6DOL6WWoSsK3M_uzQu0HOisbJ4W7J69Gjky1Xo1rGg@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CA+FnnTzq6DOL6WWoSsK3M_uzQu0HOisbJ4W7J69Gjky1Xo1rGg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/fb0589a1-701f-4447-9c49-7001e14e09a5%40aklaver.com>
Precedence: bulk

On 3/7/26 12:11 AM, Igor Korot wrote:
> Hi, David,

>> You are asking the wrong question.  The right question is “how does one turn an empty array into the null value?”  Nullif is correct, you just need to specify an empty array (of the correct type) for the second argument.
> 
> I don't think pg_class.reloptions is an ARRAY...

I think it is:

https://www.postgresql.org/docs/current/catalog-pg-class.html

reloptions text[]


> Included is one, storage is not.
> 
> Thank you.
> 
>>
>> Given that error message, an array of text is the correct type.
>>
>> Array[]::text[]
>>
>> David J.
>>
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com