I need to set up a is_numeric function in Postgres to return true or false

Question

I am trying to make a database-level function Postgres (version 9.4) to check that a given variable is numeric.

Been messing around but can't figure this out easily and wondering if there is some built in function for htis...

Possible duplicate of [isnumeric() with PostgreSQL](http://stackoverflow.com/questions/16195986/isnumeric-with-postgresql) — mvp, May 18 '16 at 21:17

score 1 · Accepted Answer · edited May 23 '17 at 12:08

1

Try this one:

CREATE OR REPLACE FUNCTION  is_number(text) RETURNS  boolean AS $$
DECLARE x NUMERIC;
BEGIN
    x = $1::NUMERIC;
    RETURN TRUE;
EXCEPTION WHEN others THEN
    RETURN FALSE;
END;
$$ LANGUAGE plpgsql IMMUTABLE;

After googling, I've found duplicate

edited May 23 '17 at 12:08

Community

1
1

answered Jul 27 '15 at 20:35

Beri

11,470
4
35
57

I need to set up a is_numeric function in Postgres to return true or false

1 Answers1