Re: SQL state: 22P02 - Mailing list pgsql-sql

On Nov 22, 2007 11:24 AM, Franklin Haut <franklin.haut@gmail.com> wrote:
>    num      return
>    ----     ------
>    0         0
>    null      false
>    12        12
>    a         false
>    12ab      false
>
>  it´s possible get these results ?

Try:

SELECT   NUM , CASE     WHEN TRIM(NUM) ~ '^[0-9]+(.[0-9]+){0,1}$'     THEN NUM     ELSE 'false'   END AS RETURN
FROM TEST;