Re: Return trimmed string from the query

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Igor Korot <ikorot01(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Return trimmed string from the query
Date: 2026-11-02 12:10:42
Message-ID: auh9wivxJA02g5fJ@depesz.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-odbc

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message loganathan P 2026-11-04 06:22:45 Application Error When Accessing the Table – PostgreSQL 15.18
Previous Message Adrian Klaver 2026-11-01 15:49:26 Re: Return trimmed string from the query

Browse pgsql-odbc by date

  From Date Subject
Next Message Igor Korot 2026-11-05 02:56:25 Re: Return trimmed string from the query
Previous Message Adrian Klaver 2026-11-01 15:49:26 Re: Return trimmed string from the query