Re: Case of strings

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   |
+------------------------------+---------------------------------------------+