Re: How to properly use TRIM()?

On Saturday, March 7, 2026, Igor Korot <ikorot01@gmail.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[]

David J.