substring and POSIX re's

Поиск
Список
Период
Сортировка
От Don Isgitt
Тема substring and POSIX re's
Дата
Msg-id 42652186.5050306@soundenergy.com
обсуждение исходный текст
Ответы Re: substring and POSIX re's  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi.

First: PG version 7.4 and 8.0.

I have a question regarding the following simplified query:


gds2=# select substring('NE NE SE 2310 FSL 330 FEL' from '^([A-Z][A-Z] )+');
 substring
-----------
 SE
(1 row)

The pg docs say that this form of substring uses POSIX re's, and my
understanding of POSIX re's is they are always greedy. So, why do I get
only SE instead of NE NE SE? Pilot error, probably, but would someone
please enlighten me? Thank you very much.

Don

p.s. The target string can have from 1 to 6 of the 2 char strings, not
just 3 as shown in this example.

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Simplified (a-la [G|N]DBM) DB access
Следующее
От: Harald Fuchs
Дата:
Сообщение: Finding FOREIGN KEY constraints via information_schema