Re: FW: BUG #17258: Unexpected results in CHAR(1) data type

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: David(at)calascibetta(dot)com
Cc: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: FW: BUG #17258: Unexpected results in CHAR(1) data type
Date: 2021-10-29 21:08:09
Message-ID: CAKFQuwYCKt3Qncx-YiRg1QRSDx4DROARgtFQWZmNPbWneQbicA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Oct 29, 2021 at 2:06 PM David M. Calascibetta <
david(at)calascibetta(dot)com> wrote:

> I disagree about it being a feature request.
>
> I was only using substr to demonstrate the problem.
>
> Here is the problem without using any functions:
>
>
>
> create table x (a char(1));
>
> insert into x values ('x');
>
> insert into x values (' ');
>
> select length(a) from x;
>
> 1
>
> 0
>
>
>

If length(a) isn't a function call then what is it?

David J.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Kamigishi Rei 2021-10-29 21:08:25 Re: BUG #17245: Index corruption involving deduplicated entries
Previous Message David M. Calascibetta 2021-10-29 21:06:02 RE: FW: BUG #17258: Unexpected results in CHAR(1) data type