| 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.
>>>
>>>
>
>
| 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 |
| 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 |