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
