Re: regexp_matches for digit
| От | Ramesh T |
|---|---|
| Тема | Re: regexp_matches for digit |
| Дата | |
| Msg-id | CAK8Zd=v4d_qn_vmJx4_pPVF3fW1jW0nnECnDdtSYk__oz+9xBA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: regexp_matches for digit (Chris Mair <chris@1006.org>) |
| Список | pgsql-general |
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 <chris@1006.org> wrote:
[:digit:] is Posix syntax, supported by Postgres.> 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
Looks good to me:
graal=# select regexp_matches('2015-07-09',
'[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2}','i');
regexp_matches
----------------
{2015-07-09}
(1 row)
graal=# select regexp_matches('2015-x7-09',
'[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2}','i');
regexp_matches
----------------
(0 rows)
What do you need, exactly?
Bye,
Chris.
В списке pgsql-general по дате отправления: