Re: How to properly use TRIM()?

Hi, David,

On Fri, Mar 6, 2026 at 11:41 PM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Saturday, March 7, 2026, Igor Korot <ikorot01(at)gmail(dot)com> wrote:
>
>>
>> included, NULLIF( TRIM( c.reloptions ), '' ) AS storage FROM pg_index
>> idx, pg_class c, pg_namespace n, pg_class t, pg_indexes ixs WHERE
>> ixs.indexname = c.relname AND c.oid = idx.indexrelid AND t.oid =
>> idx.indrelid AND n.oid = c.relnamespace AND idx.indisprimary AND
>> n.nspname = 'public' AND t.relname = 'leagues';
>> ERROR: function pg_catalog.btrim(text[]) does not exist
>> LINE 1: ...num) OFFSET idx.indnkeyatts) AS included, NULLIF( TRIM( c.re...
>>
>
>
> 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.
>
> Given that error message, an array of text is the correct type.
>
> Array[]::text[]
>

So what is the proper syntax?

Thank you.

> David J.
>
>