Return trimmed string from the query

From: Igor Korot <ikorot01(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Return trimmed string from the query
Date: 2026-11-01 07:17:10
Message-ID: CA+FnnTwZFTaBGvaQc1eqkgFJkev+BSbsn1oTaWwbKE5BLfKNRw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-odbc

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 "?

Thank you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Korot 2026-11-01 15:13:10 Fwd: Return trimmed string from the query
Previous Message Pavel Stehule 2026-11-01 07:02:45 Re: Return trimmed string from the query

Browse pgsql-odbc by date

  From Date Subject
Next Message Igor Korot 2026-11-01 15:13:10 Fwd: Return trimmed string from the query
Previous Message Pavel Stehule 2026-11-01 07:02:45 Re: Return trimmed string from the query