ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Warren <war...@clarksnutrition.com>
Subject regex in WHERE clause
Date Sat, 30 Jun 2007 02:26:45 GMT
I am trying to get the following to work:

<![CDATA[SELECT * FROM table WHERE substring(trim(field8) from '....$') 
~ '[1-9][0-9]\\.[0-9]$']]>

It does not work but this will:

<![CDATA[SELECT * FROM table WHERE substring(trim(field8) from 'a') ~ 'a']]>

When I place the $ character in it it breaks. Do I need to be doing some 
sort of escaping. The top statement works fine when I run it in pgamin.


-- 
Thanks,

Warren Bell

Mime
View raw message