MIME-Version: 1.0
In-Reply-To: <CA+FnnTxGOqF1DN4e70KXRJakuPV_V7_vGonQTX4eEOEE92PCKw@mail.gmail.com>
References: <CA+FnnTxGOqF1DN4e70KXRJakuPV_V7_vGonQTX4eEOEE92PCKw@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sat, 7 Mar 2026 00:41:43 -0700
Message-ID: <CAKFQuwakY0c3x=2o=gQ6Cr7jQ=DgE_snL1cHf8Oj+irO1fmjEQ@mail.gmail.com>
Subject: Re: How to properly use TRIM()?
To: Igor Korot <ikorot01@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000002c5d7b064c6a4d54"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwakY0c3x%3D2o%3DgQ6Cr7jQ%3DDgE_snL1cHf8Oj%2BirO1fmjEQ%40mail.gmail.com>
Precedence: bulk

--0000000000002c5d7b064c6a4d54
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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 =3D c.relname AND c.oid =3D idx.indexrelid AND t.oid =3D
> idx.indrelid AND n.oid =3D c.relnamespace AND idx.indisprimary AND
> n.nspname =3D 'public' AND t.relname =3D '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 =E2=80=9Chow does=
 one
turn an empty array into the null value?=E2=80=9D  Nullif is correct, you j=
ust 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.

--0000000000002c5d7b064c6a4d54
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Saturday, March 7, 2026, Igor Korot &lt;<a href=3D"mailto:ikorot01@gmail=
.com">ikorot01@gmail.com</a>&gt; wrote:<br><blockquote class=3D"gmail_quote=
" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><=
br>
included, NULLIF( TRIM( c.reloptions ), &#39;&#39; ) AS storage FROM pg_ind=
ex<br>
idx, pg_class c, pg_namespace n, pg_class t, pg_indexes ixs WHERE<br>
ixs.indexname =3D c.relname AND c.oid =3D idx.indexrelid AND t.oid =3D<br>
idx.indrelid AND n.oid =3D c.relnamespace AND idx.indisprimary AND<br>
n.nspname =3D &#39;public&#39; AND t.relname =3D &#39;leagues&#39;;<br>
ERROR:=C2=A0 function pg_catalog.btrim(text[]) does not exist<br>
LINE 1: ...num) OFFSET idx.indnkeyatts) AS included, NULLIF( TRIM( c.re...<=
br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
=C2=A0</blockquote><div><br></div><div>You are asking the wrong question.=
=C2=A0 The right question is =E2=80=9Chow does one turn an empty array into=
 the null value?=E2=80=9D =C2=A0Nullif is correct, you just need to specify=
 an empty array (of the correct type) for the second argument.</div><div><b=
r></div><div>Given that error message, an array of text is the correct type=
.</div><div><br></div><div>Array[]::text[]</div><div><br></div><div>David J=
.</div><div><br></div>

--0000000000002c5d7b064c6a4d54--