Re: Is this a bug ? - Mailing list pgsql-general

From Geoff Winkless
Subject Re: Is this a bug ?
Date
Msg-id CAEzk6fc3Xk7xQo_p5o-RB3CKzZd_kDCnSrPnobK+9bd-yzfXGg@mail.gmail.com
Whole thread Raw
In response to Re: Is this a bug ?  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Is this a bug ?
List pgsql-general
On Wed, 23 Oct 2019 at 16:55, Ron <ronljohnsonjr@gmail.com> wrote:
> Then -- since the 'e' is separated from 'd' by a comma, the result should be
> "4", not "3".
>
> No doubt: it's a bug, no matter what the Pg devs say.

I'm confused why you consider that to be true. The count is checking
for columns containing the strings 'a', 'b', 'cd' or 'e'. There is not
one with 'cd', so the correct result is 3.

Geoff



pgsql-general by date:

Previous
From: Fabio Ugo Venchiarutti
Date:
Subject: Re: Is this a bug ?
Next
From: "David G. Johnston"
Date:
Subject: Re: jsonb_set() strictness considered harmful to data