On 7/9/2015 11:24 AM, Ramesh T wrote:
Hi, in oracle regexp_like(entered date,'[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2}','i')for postgres i have regexp_matches ,But i need how to match [:digit:] in postgres when we pass date..? any help
\d per: http://www.postgresql.org/docs/devel/static/functions-matching.html # select 1 where '1234-56-78' ~ '\d{4}-\d{2}-\d{2}'; ?column? ---------- 1 (1 row) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
