[linux] PostgresSQL a case sensitive

[jeeff - Lubos Balat]

Hi

neviete ako presvedcit postgres aby mu bolo jedno ci je text malym alebo
velkym pismenom. Robi mi to problem pri vyhladavani v tabulkach ked
select * from xxx where meno like 'Jano%' nie je to iste ako like
'jano%'
Uzivatel musi do formulara zadat pekne Jano... a to je niekedy dost blbe

--
Lubos Balat - jeeff
jeeff na fornax.elf.stuba.sk
http://fornax.elf.stuba.sk/~jeeff     (osobna stranka)
http://fornax.elf.stuba.sk/webdesign  (moj projekt na fornaxe)
http://come.to/jeeff                  (zoznam mojich filmov)