Re: regexp_matches for digit

From: Jimit Amin <jimitamin9(at)gmail(dot)com>
To: Ramesh T <rameshparnanditech(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, Pavel Stěhule <pavel(dot)stehule(at)gmail(dot)com>
Subject: Re: regexp_matches for digit
Date: 2015-07-09 16:46:29
Message-ID: CA+4ipfJkiaxcNxpq+PeO4guSqPTYGtY6ZmJu-EJubvpinSKiuA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rames,

Hope this will be useful

http://www.postgresql.org/docs/9.1/static/functions-string.html

Jimit Amin

On Thu, Jul 9, 2015 at 9:54 PM, Ramesh T <rameshparnanditech(at)gmail(dot)com>
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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2015-07-09 16:46:50 Index Only Scan vs Cache
Previous Message Ramesh T 2015-07-09 16:24:01 regexp_matches for digit