Re: Return trimmed string from the query

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Igor Korot <ikorot01(at)gmail(dot)com>, Pavel Stehule <pavel(dot)stehule(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-05 04:50:20
Message-ID: c440e4a8-2527-4be8-9b20-c3d56109fd5d@aklaver.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-odbc

On 11/4/26 6:56 PM, Igor Korot wrote:
> Hi,
>

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

It is all explained in the docs:

https://www.postgresql.org/docs/current/datatype-character.html

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

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message BUBACZ Martin 2026-11-05 10:53:17 Update pg_stat_monitor failed
Previous Message Pavel Stehule 2026-11-05 04:49:43 Re: Return trimmed string from the query

Browse pgsql-odbc by date

  From Date Subject
Next Message Igor Korot 2026-11-15 07:11:38 Problem retrieving data
Previous Message Pavel Stehule 2026-11-05 04:49:43 Re: Return trimmed string from the query