On Sun, Nov 1, 2026 at 1:43 AM Igor Korot <[email protected]> wrote:
> hi, ALL, > Is there an option to return a trimmed string from the query? > > If I try to retrieve the char(10) from the table and the field only have > "abc", how to prevent the value to be returned as "abc "? > TRIM() is the portable/standards method: SELECT TRIM(TRAILING ' ' FROM a) FROM foo; There are many useful string functions: https://www.postgresql.org/docs/17/functions-string.html -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster!
