regexp_matches problem

Поиск
Список
Период
Сортировка
От WP Perquin
Тема regexp_matches problem
Дата
Msg-id 8D4F705289524C3586CCAC88EE83BB99@yuploung008f4f
обсуждение исходный текст
Ответы Re: regexp_matches problem
Список pgsql-general

(postgresql 8.3.7, linux centos)

I made the following regexp_matches

SELECT regexp_matches(
    (
        SELECT content
        FROM page
        WHERE idpage = 2
    )
    ,','<img\\s+((title="[^"]+")|(alt="[^"]+")|([^>]))*>'
    , 'ig'
) AS result

 

The result looks like: {"\"",NULL,NULL,"\""} in phpPgAdmin.

Which is not the right result. I want to see als the images and their alt, title and src.

 

Can anyone help with telling what I am doing wrong?

 

Willem

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