Re: is_numeric() or extract_numeric() functions?

Thanks everyone, that worked and I now have a new plpgsql function to
extract numbers from a string. I placed it in the PL/pgSQL CookBook
(linked from the Users Lounge on the postgres home page ->
http://www.brasileiro.net:8080/postgres/cookbook/) if anyone wants it.


Tom Lane wrote:

>"Ron St.Pierre" <rstpierre@syscor.com> writes:
>
>
>>CREATE OR REPLACE FUNCTION getnumber(varchar(1)) RETURNS integer AS '
>>        BEGIN
>>            return ($1 ~ '[0-9]');
>>        END;
>>' LANGUAGE 'plpgsql';
>>
>>
>
>
>
>>I get the following error:
>>  parse error at or near "["
>>
>>
>
>You need to double the quotes in the function body, viz
>
>    ...
>            return ($1 ~ ''[0-9]'');
>    ...
>
>Backslash-quote (\') is an alternative way.
>
>            regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>


--
Ron St.Pierre
Syscor R&D
tel: 250-361-1681
email: rstpierre@syscor.com