"Brett W. McCoy" <bmccoy(at)chapelperilous(dot)net> writes:
> The case-insensitive regexp operator is ~*, and it does work in
> PostgreSQL. There is no ~~* or ILIKE,
Both are new for 7.1, I believe.
> but you can do LIKE UPPER('*text*')
> to achieve the same thing.
Good workaround for older versions.
Alan appears to have been reading the development docs rather than
the release-version docs ...
regards, tom lane