On Sat, 2026-09-26 at 08:27 +0000, PG Doc comments form wrote:
> AI generated ))
Then please validate the generated stuff rather than creating
extra work.
> The following SQL statement contains an unquoted regular-expression-like
> expression:
>
> db=# WITH products (id, name, price, action) AS
> (
> VALUES
> (1, 'apple', 100, '...')
> , (2, 'banana', 200, '...')
> , (3, 'orange', 150, '...')
> , (4, 'potato', 80, '...')
> , (5, 'tomato', 120, '...')
> )
> SELECT
> p.id
> , p.name
> , p.price
> , p.action
> FROM products AS p
> WHERE regexp_like(p.action, ((?<!-)\d+))
> ;
>
> [the complaint is that you get a list of tables rather than a result]
There is no bug there. The statement is *not* a regular expression,
because the single quotes around the string literal are missing.
As a consequence, a metacommand (\d+) is executed. That "swallows"
the two closing parentheses, and psql prompts you to close the two
parentheses and end the statement. If you do that, you get the
syntax error you deserve.
In short: garbage in, garbage out. No bug.
Yours,
Laurenz Albe
