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 expr
On Fri, Feb 27, 2004 at 12:06:58PM -, Simon Windsor wrote:
> Hi
>
> I have moved an application from MySQL to PgSQL, and after the making
> changes I thought all was ok.
>
> However, I have just realised that
>
> Where A = 'STRING'
>
> Is not the same as
>
> Where A ='String'
This is sta
>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')
I think you already answered your own question as pgsql
document does in section
"9.4. String Functions and
Hi
I have moved an application from MySQL to PgSQL, and after
the making changes I thought all was ok.
However, I have just realised that
Where A = ‘STRING’
Is not the same as
Where A =’String’
Is there anyway I can force the PgSQL to accept case
equivalence, or mus
