(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