"Robert B. Easter" <reaster@comptechnews.com> writes:
> These links might be useful:
> http://www.postgresql.org/docs/aw_pgsql_book/node52.html
> http://www.scriptics.com/man/tcl8.4/TclCmd/regexp.htm
> Pg uses '~' as the regexp operator, so you can try that instead of the '='.
Pg's regexp package is pretty old and limited --- I believe it just
implements some POSIX spec or other, not all the fancy stuff you find
in TCL or Perl regexps nowadays.
If you need some non-POSIX regexp feature, try making a TCL regexp
function, say
create function tcl_regexp(text,text) returns bool as
'regexp -- $1 $2' language 'pltcl';
Then you use this in SQL queries like
SELECT ... WHERE tcl_regexp('pattern', variable);
In general, pltcl or plperl make great implementation languages for
text-mashing functions, so I don't feel any big hurry to improve
our built-in SQL functions to try to equal them...
regards, tom lane