| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Igor Korot <ikorot01(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:49:43 |
| Message-ID: | CAFj8pRBg5SfrN-zUzJHAjKMqXV_vPgDdYjE1kT1kcC1Tx3juwg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-odbc |
čt 5. 11. 2026 v 3:56 odesílatel Igor Korot <ikorot01(at)gmail(dot)com> napsal:
> Hi,
>
> On Sun, Nov 1, 2026 at 12:03 AM Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
> wrote:
> >
> > 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 │
> > └────────────┴─────┘
>
> Sorry for a late reply.
>
> So does this mean that if I use varchar instead of char I will not
> have this problem?
>
sure.
char(n) type is "strange". It is designed for compatibility with old Cobol
databases, and there is not any benefit for their usage today.
Regards
Pavel
>
> Thank you,
>
> > (1 row)
> >
> > regards
> >
> > Pavel
> >
> >>
> >>
> >> Thank you.
> >>
> >>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2026-11-05 04:50:20 | Re: Return trimmed string from the query |
| Previous Message | Rob Sargent | 2026-11-05 04:48:09 | Re: Return trimmed string from the query |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2026-11-05 04:50:20 | Re: Return trimmed string from the query |
| Previous Message | Rob Sargent | 2026-11-05 04:48:09 | Re: Return trimmed string from the query |