On Sun, Nov 01, 2026 at 01:17:10AM -0600, Igor Korot 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 "?
Others already helped, but also, please read: https://wiki.postgresql.org/wiki/Don%27t_Do_This#Don't_use_char(n) Best regards, depesz
