pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Peter Eisentraut <peter@eisentraut.org>
To: David G. Johnston <david.g.johnston@gmail.com>
To: Anmol Mohanty <anmol.mohanty@salesforce.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18765: Inconsistent behaviour and errors with LIKE
Date: Wed, 8 Jan 2025 21:52:29 +0100
Message-ID: <83c66908-ff3e-4aa1-8d90-1647d8dc8baa@eisentraut.org> (raw)
In-Reply-To: <CAKFQuwYPO3gfsHekjt4Y1B9QgrY-psXDr3VgMXTtZpU1YYBwOA@mail.gmail.com>
References: <18765-6c26d2047e6f5143@postgresql.org>
	<CAKFQuwaoWrRuM544zDqnTg2wnB8fkQgOe0qAHrvHmDQgAyLGcw@mail.gmail.com>
	<CAPKoE6y+5vk5S4fVGgkFsO1pPDiGo=LLJd0o36ChQYzyZhVpMQ@mail.gmail.com>
	<CAKFQuwYPO3gfsHekjt4Y1B9QgrY-psXDr3VgMXTtZpU1YYBwOA@mail.gmail.com>

On 06.01.25 20:25, David G. Johnston wrote:
> On Mon, Jan 6, 2025 at 12:07 PM Anmol Mohanty 
> <anmol.mohanty@salesforce.com <mailto:anmol.mohanty@salesforce.com>> wrote:
> 
>     This is a violation of the SQL standard.
> 
> We do discuss where we vary from the SQL Standard in the 
> documentation for LIKE so a sentence covering this deviation seems 
> warranted.

I have also come across this issue recently, and I think we should 
actually fix it.  It makes sense to verify that the pattern is 
syntactically correct before trying to use it, instead of just using it 
incrementally and then erroring when you happen to hit the problematic bits.





view thread (6+ messages)  latest in thread

Message-ID: <83c66908-ff3e-4aa1-8d90-1647d8dc8baa@eisentraut.org>
Permalink:  ../83c66908-ff3e-4aa1-8d90-1647d8dc8baa@eisentraut.org/
Also on:    postgresql.org/message-id/83c66908-ff3e-4aa1-8d90-1647d8dc8baa@eisentraut.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: peter@eisentraut.org, david.g.johnston@gmail.com, anmol.mohanty@salesforce.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: BUG #18765: Inconsistent behaviour and errors with LIKE
  In-Reply-To: <83c66908-ff3e-4aa1-8d90-1647d8dc8baa@eisentraut.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox