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