(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
