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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
