(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

Reply via email to