Re: How to properly use TRIM()?

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Igor Korot <ikorot01(at)gmail(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: How to properly use TRIM()?
Date: 2026-03-07 19:19:52
Message-ID: F6C9D4E2-2FC5-43B4-89F3-46C5A0A770B4@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general



reloptions text[]




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




Or it’s an ARRAY() implementation?




Thank you.





One is an empty array, the other is null. Those are not the same thing. 




> 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(dot)klaver(at)aklaver(dot)com



In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Korot 2026-03-07 19:58:22 Re: How to properly use TRIM()?
Previous Message Igor Korot 2026-03-07 19:15:27 Re: How to properly use TRIM()?