Looking for a subsequence in a numeric field

[David Marí]

Hi,

Im porting an old application and I have a situation dealing with the existing database where I need to find a subsequence inside a numeric field.

I’m working on top of PostgreSQL and with raw SQL and what I see in the old implementation of the application is that they do intfield::text ILIKE '%42%'

Is there a way to achieve the same using the like match operator? How can I cast the integer field to a string type?

Thanks,

--

David Marí

dap...@gmail.com

[David Marí]

Hello,

Checking the source it looks like it could be implemented in a similar way to ToUpperCase and ToLowerCase in StatementWhere.scala and then adding a new case in QlIdiom.scala (toSqlDmlFunctionApply)

If I'm right I could try to contribute it.

Let me know.

Thanks,

David.

El dijous, 24 setembre de 2015 7:59:40 UTC+2, David Marí va escriure: