Re: Postgres friendly RegEx?
От
Jon Asher
Тема
Re: Postgres friendly RegEx?
Дата
Msg-id
d24c7af0612121501p640531ecub023c353cda6c8b1@mail.gmail.com
Ответ на
Re: Postgres friendly RegEx? (Tom Lane)
Список
Дерево обсуждения
Postgres friendly RegEx? "Jon Asher" <jon.asher@gmail.com>
Re: Postgres friendly RegEx? Tom Lane <tgl@sss.pgh.pa.us>
Re: Postgres friendly RegEx? "Jon Asher" <jon.asher@gmail.com>
Re: Postgres friendly RegEx? "Jon Asher" <jon.asher@gmail.com>
In Postgres, it appears to be returning false positives:
select * from
(select '52'::varchar As val) d
where d.val ~ '-{0,1}\\d*\\.{0,1}\\d+\\^{0,1}\\d*\\.{0,1}\\d+'
returns a record.
(select '52'::varchar As val) d
where d.val ~ '-{0,1}\\d*\\.{0,1}\\d+\\^{0,1}\\d*\\.{0,1}\\d+'
returns a record.
In C++ only such values match: 45.2^3 or -45.2^3 or 10^2.5
On 12/12/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Jon Asher" <jon.asher@gmail.com> writes:
> Anyone care to correct this regex for PostgreSQL? It works in C++ but
> Postgres have no love for it:
> -{0,1}\d*\.{0,1}\d+\^{0,1}\d*\.{0,1}\d+
It works fine in Postgres, AFAICT. Maybe you forgot to double the
backslashes in a string literal? Otherwise, be more specific about
your problem.
regards, tom lane
В списке pgsql-general по дате отправления
