MIME-Version: 1.0
References: <CA+FnnTxGOqF1DN4e70KXRJakuPV_V7_vGonQTX4eEOEE92PCKw@mail.gmail.com>
 <CAKFQuwakY0c3x=2o=gQ6Cr7jQ=DgE_snL1cHf8Oj+irO1fmjEQ@mail.gmail.com>
 <CA+FnnTzq6DOL6WWoSsK3M_uzQu0HOisbJ4W7J69Gjky1Xo1rGg@mail.gmail.com> <fb0589a1-701f-4447-9c49-7001e14e09a5@aklaver.com>
In-Reply-To: <fb0589a1-701f-4447-9c49-7001e14e09a5@aklaver.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Sat, 7 Mar 2026 11:13:42 -0800
Message-ID: <CA+FnnTwxSeLhR8zNZsoR2SAXYVf9Db+zi3+SpPqdBe==m3X-AQ@mail.gmail.com>
Subject: Re: How to properly use TRIM()?
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000072bff3064c73f854"
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTwxSeLhR8zNZsoR2SAXYVf9Db%2Bzi3%2BSpPqdBe%3D%3Dm3X-AQ%40mail.gmail.com>
Precedence: bulk

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

Hi, Adrian,

On Sat, Mar 7, 2026 at 7:44=E2=80=AFAM Adrian Klaver <adrian.klaver@aklaver=
.com>
wrote:

> On 3/7/26 12:11 AM, Igor Korot wrote:
> > Hi, David,
>
> >> 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=
 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[]


Then why it=E2=80=99s not showing {} as in the =E2=80=9Cincluded=E2=80=9D c=
olumns?

Or it=E2=80=99s an ARRAY() implementation?

Thank you.


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

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

<div dir=3D"auto">Hi, Adrian,</div><div><br><div class=3D"gmail_quote gmail=
_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Sat, Mar 7, 2026=
 at 7:44=E2=80=AFAM Adrian Klaver &lt;<a href=3D"mailto:adrian.klaver@aklav=
er.com">adrian.klaver@aklaver.com</a>&gt; wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex">On 3/7/26 12:11 AM, Igor Korot wrote:<br>
&gt; Hi, David,<br>
<br>
&gt;&gt; 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=A0 =
Nullif is correct, you just need to specify an empty array (of the correct =
type) for the second argument.<br>
&gt; <br>
&gt; I don&#39;t think pg_class.reloptions is an ARRAY...<br>
<br>
I think it is:<br>
<br>
<a href=3D"https://www.postgresql.org/docs/current/catalog-pg-class.html" r=
el=3D"noreferrer" target=3D"_blank">https://www.postgresql.org/docs/current=
/catalog-pg-class.html</a><br>
<br>
reloptions text[]</blockquote><div dir=3D"auto"><br></div><div dir=3D"auto"=
>Then why it=E2=80=99s not showing {} as in the =E2=80=9Cincluded=E2=80=9D =
columns?</div><div dir=3D"auto"><br></div><div dir=3D"auto">Or it=E2=80=99s=
 an ARRAY() implementation?</div><div dir=3D"auto"><br></div><div dir=3D"au=
to">Thank you.</div><div dir=3D"auto"><br></div><blockquote class=3D"gmail_=
quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1=
ex" dir=3D"auto"><br>
<br>
<br>
&gt; Included is one, storage is not.<br>
&gt; <br>
&gt; Thank you.<br>
&gt; <br>
&gt;&gt;<br>
&gt;&gt; Given that error message, an array of text is the correct type.<br=
>
&gt;&gt;<br>
&gt;&gt; Array[]::text[]<br>
&gt;&gt;<br>
&gt;&gt; David J.<br>
&gt;&gt;<br>
&gt; <br>
&gt; <br>
<br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klave=
r@aklaver.com</a><br>
</blockquote></div></div>

--00000000000072bff3064c73f854--