Horton
Menu

Re: How to properly use TRIM()?

Rob Sargent <robjsargent@gmail.com>

View thread
From: Rob Sargent <robjsargent@gmail.com>
To: Igor Korot <ikorot01@gmail.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, "David G. Johnston" <david.g.johnston@gmail.com>, "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2026-03-07T19:19:52Z
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.klaver@aklaver.com