Re: [ADMIN] Case insensitive

[Garry Dolley]

Aditya Kotturu wrote:
> 
> Hi,
> 
> Is there any admin option I can set for a particular database in the
> Postgres so that all queries directed towards that database are made case
> insensitive?
> 
> i.e the below 2 queries mean the same.
> 
> select * from userdata wher name = 'John'
> 
> select * from userdata wher name = 'joHN'
Try this:

select * from userdata where lower(name) = 'john'

That's how I make things case insensitive..

-- 
Garry Dolley
Webmaster/Technical Contact
LinuxStart.Com