Use $$ instead. On 6/29/07, Warren <[EMAIL PROTECTED]> 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
