Fwd: Return trimmed string from the query

From: Igor Korot <ikorot01(at)gmail(dot)com>
To: PostgreSQL ODBC list <pgsql-odbc(at)postgresql(dot)org>
Subject: Fwd: Return trimmed string from the query
Date: 2026-11-01 15:13:10
Message-ID: CA+FnnTzHK2ayqodg_2y5wAmyegHMxp0fzWg+3hzFML8NsbkAcA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-odbc

Hi,
Is there an option in the DM to do the same?

If not - how to do it with ODBC?

Thx.

---------- Forwarded message ---------
From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Date: Sun, Nov 1, 2026 at 12:03 AM
Subject: Re: Return trimmed string from the query
To: Igor Korot <ikorot01(at)gmail(dot)com>
Cc: pgsql-generallists.postgresql.org <pgsql-general(at)lists(dot)postgresql(dot)org>

Hi

ne 1. 11. 2026 v 7:43 odesílatel Igor Korot <ikorot01(at)gmail(dot)com> napsal:
>
> 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 "?

no, there is not any option, you need to cast result value to varchar;

(2026-11-01 07:57:03) postgres=# create table foo(a char(10));
CREATE TABLE
(2026-11-01 08:01:49) postgres=# insert into foo values('abc');
INSERT 0 1
(2026-11-01 08:02:03) postgres=# select a, a::varchar from foo;
┌────────────┬─────┐
│ a │ a │
╞════════════╪═════╡
│ abc │ abc │
└────────────┴─────┘
(1 row)

regards

Pavel

>
>
> Thank you.
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2026-11-01 15:13:18 Re: Return trimmed string from the query
Previous Message Igor Korot 2026-11-01 07:17:10 Return trimmed string from the query

Browse pgsql-odbc by date

  From Date Subject
Next Message Ron Johnson 2026-11-01 15:13:18 Re: Return trimmed string from the query
Previous Message Igor Korot 2026-11-01 07:17:10 Return trimmed string from the query