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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

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