regexp_matches for digit

From: Ramesh T <rameshparnanditech(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, Pavel Stěhule <pavel(dot)stehule(at)gmail(dot)com>
Subject: regexp_matches for digit
Date: 2015-07-09 16:24:01
Message-ID: CAK8Zd=u-kJ3LaAJOy5Ac2tt8Hq_JzXEi5Mfn_e_sa0qymgRXUg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jimit Amin 2015-07-09 16:46:29 Re: regexp_matches for digit
Previous Message David Steele 2015-07-09 14:06:03 Re: Backup Method