Re: Return trimmed string from the query

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Igor Korot <ikorot01(at)gmail(dot)com>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, "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-05 04:48:09
Message-ID: B14DD367-C5E9-4EE9-8F8B-05EF6315430B@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-odbc

> Sorry for a late reply.
>
> So does this mean that if I use varchar instead of char I will not
> have this problem?
>
> Thank you,

Yes. If you use text rather char(n) you will not get space-padded values.

If you have char(n) fields already you have work to do to irradiate them. It will be effort well spent though.

>
>> (1 row)
>>
>> regards
>>
>> Pavel
>>
>>>
>>>
>>> Thank you.
>>>
>>>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2026-11-05 04:49:43 Re: Return trimmed string from the query
Previous Message Ron Johnson 2026-11-05 03:48:33 Re: Application Error When Accessing the Table – PostgreSQL 15.18

Browse pgsql-odbc by date

  From Date Subject
Next Message Pavel Stehule 2026-11-05 04:49:43 Re: Return trimmed string from the query
Previous Message Igor Korot 2026-11-05 02:56:25 Re: Return trimmed string from the query