From: Tom Lane <tgl@sss.pgh.pa.us>
To: sulfinu@gmail.com
cc: pgsql-bugs@lists.postgresql.org
Subject: Re: The jsonpath predicate `like_regex` does not accept variables for
 pattern (or flags)
In-reply-to: 
 <CAGH1kmz2QT+m2Lr8ts=YWDq+435JWZ2MPFE2WpS2yFh2HQrQ5g@mail.gmail.com>
References: 
 <CAGH1kmz2QT+m2Lr8ts=YWDq+435JWZ2MPFE2WpS2yFh2HQrQ5g@mail.gmail.com>
Comments: In-reply-to sulfinu@gmail.com
	message dated "Tue, 06 Aug 2024 19:42:09 +0300"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1799748.1722966629.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Tue, 06 Aug 2024 13:50:29 -0400
Message-ID: <1799749.1722966629@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1799749.1722966629%40sss.pgh.pa.us>
Precedence: bulk

sulfinu@gmail.com writes:
> I would like to be able to use a variable inside the like_regex predicat=
e,
> at least for the pattern.

This was discussed before [1].  The restriction to a constant pattern
is per SQL spec.  It's not entirely clear to us why the spec is
written that way, but there may be some actual semantic point behind
it.  In any case, if you want to propose a patch, that thread would
probably be the best place to do it.

			regards, tom lane

[1] https://www.postgresql.org/message-id/flat/CAGHENJ4A8awD2uXHkf50eV%2B9=
wyiDm3eP%2BG10J09%2B0VRmXBQAdw%40mail.gmail.com