Re: how to ignore case

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: lorid <lorid(at)dri(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: how to ignore case
Date: 2005-05-19 19:30:53
Message-ID: 1116531053.31821.107.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tomeh, Husam 2005-05-19 21:55:20 Re: Can you generate SQL by using SQL in Postgres?
Previous Message Scott Marlowe 2005-05-19 19:20:16 Re: how to ignore case