Re: [SQL] How to Make Case InSensitive??? - Mailing list pgsql-sql

From Leslie Mikesell
Subject Re: [SQL] How to Make Case InSensitive???
Date
Msg-id 199809192248.RAA19174@Mercury.mcs.net
Whole thread Raw
In response to Re: [SQL] How to Make Case InSensitive???  (Bruce Momjian <maillist@candle.pha.pa.us>)
List 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@mcs.com

pgsql-sql by date:

Previous
From: Ian Johnston
Date:
Subject: date problem
Next
From: Karl Denninger
Date:
Subject: To create the query for a select where one is NOT in the other