On 2025-Sep-12, Tom Lane wrote: > Dominique Devienne <ddevienne@xxxxxxxxx> writes: > >> This DOES look like a bug, no? I've done regexes for a long time, > >> and these two forms should be equivalent IMHO. --DD > > Yeah, I agree it's busted. You can use EXPLAIN VERBOSE to see the > translated-to-POSIX pattern, and it's wrong: And now we also have https://postgr.es/m/41a37137-f8bb-8fc5-2948-31b528f166dc@xxxxxxxxxxxxx CC'ed the committer here. -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/ "La victoria es para quien se atreve a estar solo"