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