ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <lmead...@apache.org>
Subject Re: regex in WHERE clause
Date Sat, 30 Jun 2007 02:37:10 GMT
Use $$ instead.

On 6/29/07, Warren <warren@clarksnutrition.com> wrote:
> 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