Mike Christensen-2 wrote > I'm curious why this query returns 0: > > SELECT 'AAA' ~ '^A{,4}$' > > Yet, this query returns 1: > > SELECT 'AAA' ~ '^A{0,4}$' > > Is this a bug with the regular expression engine? Apparently since "{,#}" is not a valid regexp expression the engine simply interprets it as a literal and says 'AAA' != 'A{,4}' http://www.postgresql.org/docs/9.3/interactive/functions-matching.html#FUNCTIONS-POSIX-REGEXP Table 9-13. Regular Expression Quantifiers Note the all of the { } expressions have a lower bound (whether explicit or implied). David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Regular-expression-question-with-Postgres-tp5812777p5812778.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных