Re: [GENERAL] regexp_matches for digit

2015-07-10 Thread Ramesh T
nice i'm looking for this,i thought digit don't work in postgres.. thanks On Thu, Jul 9, 2015 at 10:21 PM, Chris Mair 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

Re: [GENERAL] regexp_matches for digit

2015-07-09 Thread Steve Crawford
On 07/09/2015 09: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 Konsole output The tilde operator wor

Re: [GENERAL] regexp_matches for digit

2015-07-09 Thread Chris Mair
> 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 [:digit:] is Posix syntax, supported by Postgres. Looks good to me:

Re: [GENERAL] regexp_matches for digit

2015-07-09 Thread Andy Colson
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/de

Re: [GENERAL] regexp_matches for digit

2015-07-09 Thread Jimit Amin
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 wrote: > Hi, > in oracle regexp_like(entered > date,'[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2}','i') > > for postgres i have regex

[GENERAL] regexp_matches for digit

2015-07-09 Thread Ramesh T
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