ILIKE in Postgres

[Ashley Moran]

Hi

Does anyone know a good way to use ILIKE in Postgres? I really want
to do this:

Model.all(:name.ilike => "%some_text%")

But DataMapper only supports

Model.all(:name.like => "%some_text%")

Which means you have to get the case correct in the search text.

Thanks
Ashley

--
http://www.patchspace.co.uk/
http://www.linkedin.com/in/ashleymoran
http://aviewfromafar.net/
http://twitter.com/ashleymoran

[Martin Gamsjaeger]

Ashley,

You could always fall back to the "classic" condition syntax, so something like

Model.all(:conditions => [ "name ILIKE ?", term ])

should work.

cheers
snusnu

[Ashley Moran]

On 5 Jul 2009, at 11:52, Martin Gamsjaeger wrote:

> You could always fall back to the "classic" condition syntax, so
> something like
>
> Model.all(:conditions => [ "name ILIKE ?", term ])

Thanks!