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(at)syscor(dot)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(at)postgresql(dot)org
>
>

--
Ron St.Pierre
Syscor R&D
tel: 250-361-1681
email: rstpierre(at)syscor(dot)com