| From: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> |
|---|---|
| To: | Simon Windsor <simon(dot)windsor(at)cornfield(dot)org(dot)uk> |
| Cc: | "pgsql-general (at) postgresql (dot) org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Case of strings |
| Date: | 2004-02-27 15:48:39 |
| Message-ID: | 20040227154839.A6600@bacon |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 27/02/2004 12:06 Simon Windsor wrote:
> Is there anyway I can force the PgSQL to accept case equivalence, or must
> I
> add upper()/lower() to force the case and then make string tests?
>
>
>
> Ie Where upper(A)=upper('String')
You could use ilike
where a ilike 'string'
You can also use POSIX regular expressions.
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jwsacksteder | 2004-02-27 16:01:54 | compartmentalizing users |
| Previous Message | Bill Moran | 2004-02-27 15:23:40 | Re: postgreSQL licenseing |