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

Re: [SQL] How to Make Case InSensitive???

From: Leslie Mikesell <les(at)Mcs(dot)Net>
To: maillist(at)candle(dot)pha(dot)pa(dot)us (Bruce Momjian)
Cc: cuda_fx(at)yahoo(dot)com, marciom(at)conectiva(dot)com(dot)br, daveh(at)insightdist(dot)com, pgsql-sql(at)postgreSQL(dot)org, srswamy(at)giasdl01(dot)vsnl(dot)net(dot)in
Subject: Re: [SQL] How to Make Case InSensitive???
Date: 1998-09-19 22:48:50
Message-ID: 199809192248.RAA19174@Mercury.mcs.net (view raw or flat)
Thread:
Lists: pgsql-sql
According to Bruce Momjian:
> 
> > thank you for this tip!  don't know what the ^ or the $ is used for
> > but the ~* and the \do helped me out a great deal.  No info on this in
> > any documentation.
> > 
> > Charles
> 
> Actually, the FAQ mentions it, the psql \? command, and psql manual page
> mention it.  Is there somewhere else we should mention it?

Is it documented which things work with which data types (text vs. varchar)?

  Les Mikesell
    les(at)mcs(dot)com

In response to

pgsql-sql by date

Next:From: Karl DenningerDate: 1998-09-19 22:55:14
Subject: To create the query for a select where one is NOT in the other
Previous:From: Ian JohnstonDate: 1998-09-19 21:53:19
Subject: date problem

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