Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> writes: > I think the confusion is about what SIMILAR TO supports. ? it doesn't. Actually, upon looking into SQL:2008, it seems it's supposed to support ? now, and also {m,n} style bounds. Those weren't there in SQL99 ... I've changed the similar_escape code to not escape ? and {, so that those things will work now, and to escape ^ and $ instead. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general