Hi!

I don't  know if this is possible from postgresql configuration...

I want to ignore the use of uppercase and lowercase from the data restored
into the DB...

I mean, if I  write a query like this:

select * from fruits where fruit_name like 'orange';

I could get any result where the string looks like:

orange
Orange
ORANGE

Is it possible???

Regards.



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Reply via email to