Using regex in redshift to find dollar values
I am getting that you want extract numbers with either '$' or even not without a dollar.

Why are not using just [0-9]+ for that field? The results will be like

    some $1 something &gt;&gt; ['1']
    some other 115 &gt;&gt; ['115']
    $115 some thing &gt;&gt; ['115']


If you want to include '\$' sign, then '\$' can be repeated zero or once or by typo more, then regex would be 

    \$*[0-9]+


which outputs

    some $1 something &gt;&gt; ['$1']
    some other 115 &gt;&gt; ['115']
    $115 some thing &gt;&gt; ['$115']


If this is not what you want, comment.

Hope this helps.

I would recommend using online regex matchers like here. They have short and sweet references which really help us get to the context.