Re: isnumeric - checking if text variable is convertable to numeric - Mailing list pgsql-general

am  25.04.2006, um  2:01:49 -0700 mailte SunWuKung folgendes:
> I tried this but couldn't find out what would be the WHEN condition for
>
> Select Cast('asdf' as numeric)
> ERROR:  invalid input syntax for type numeric

create or replace function check_numeric(varchar) returns bool as $$
declare
        i numeric;
begin
        i := $1::numeric;
        return 't'::bool;
        EXCEPTION WHEN invalid_text_representation then
                return 'f'::bool;
end;
$$ language plpgsql immutable strict;



HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===