public inbox for [email protected]  

help / color / mirror / Atom feed

From: Igor Korot <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: David G. Johnston <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: How to properly use TRIM()?
Date: Sat, 7 Mar 2026 11:13:42 -0800
Message-ID: <CA+FnnTwxSeLhR8zNZsoR2SAXYVf9Db+zi3+SpPqdBe==m3X-AQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CA+FnnTxGOqF1DN4e70KXRJakuPV_V7_vGonQTX4eEOEE92PCKw@mail.gmail.com>
	<CAKFQuwakY0c3x=2o=gQ6Cr7jQ=DgE_snL1cHf8Oj+irO1fmjEQ@mail.gmail.com>
	<CA+FnnTzq6DOL6WWoSsK3M_uzQu0HOisbJ4W7J69Gjky1Xo1rGg@mail.gmail.com>
	<[email protected]>

Hi, Adrian,

On Sat, Mar 7, 2026 at 7:44 AM Adrian Klaver <[email protected]>
wrote:

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


Then why it’s not showing {} as in the “included” columns?

Or it’s 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
> [email protected]
>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: How to properly use TRIM()?
  In-Reply-To: <CA+FnnTwxSeLhR8zNZsoR2SAXYVf9Db+zi3+SpPqdBe==m3X-AQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox