hey , i am getting empty query result while using postgres regex operator "^" , ".*" etc . I am able to use "%" correctly but not getting any response for other regex operator
As the opening paragraph of the relevant docs say:
There are three separate approaches to pattern matching provided by PostgreSQL: the traditional SQL LIKE operator, the more recent SIMILAR TO operator (added in SQL:1999), and POSIX-style regular expressions. Aside from the basic “does this string match this pattern?” operators, functions are available to extract or replace matching substrings and to split a string at matching locations.
