Home > mailing lists

Re: Bug / Unexpected behaviour of NOT LIKE - Mailing list pgsql-bugs

From	David G. Johnston
Subject	Re: Bug / Unexpected behaviour of NOT LIKE
Date	October 6, 2021 20:52:56
Msg-id	CAKFQuwZFo6dmwr-Xk2BCi7igu0BETPbaqdCWjFh=zZG=Cxws=g@mail.gmail.com Whole thread Raw
In response to	Bug / Unexpected behaviour of NOT LIKE (Judith Meyer <yutian.mei@gmail.com>)
List	pgsql-bugs

Tree view

On Wed, Oct 6, 2021 at 9:30 AM Judith Meyer <yutian.mei@gmail.com> wrote:

all occasions where someone might reasonably use NOT LIKE should be

done on fields that prohibit null values ensuring that, absent an outer join, the check for null-ness is unnecessary.

David J.

pgsql-bugs by date:

From: Tom Lane
Date: 06 October 2021, 19:52:54
Subject: Re: Bug / Unexpected behaviour of NOT LIKE

From: Andres Freund
Date: 06 October 2021, 22:10:52
Subject: Re: pg_replication_slot_advance xmin handling when active slot becomes inactive

Re: Bug / Unexpected behaviour of NOT LIKE - Mailing list pgsql-bugs

Previous

Next