# eetasoft@xxxxxxxxx / 2006-06-06 11:58:26 +0300: > How to force postgres to use index for the following query (I can change the > query to equivalent if required) > > select nimi from klient where lower(nimi) like 'test%' do you have an index on klient (lower(nimi))? -- How many Vietnam vets does it take to screw in a light bulb? You don't know, man. You don't KNOW. Cause you weren't THERE. http://bash.org/?255991