Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group