Re: how to ignore case - Mailing list pgsql-admin

On Thu, 2005-05-19 at 14:20, Scott Marlowe wrote:

> or REGEX:
>
> select * from table where lower ~* '.*abc.*';

That second one should be:

select * from table where somefield ~* '.*abc.*';

either too much or not enough coffee