Re: [GENERAL] regexp_matches problem

[WP Perquin]

When I make the following simplified example:

SELECT regexp_matches('<img src="wwww" title="dit is een title tekst"
class="class12">'

,'((title\s*=\s*\"([^"]*)")+)|((src\s*=\s*\"([^"]*)")+)','ig')

 

My result are 2 rows:

"{NULL,NULL,NULL,"src=\"wwww\"","src=\"wwww\"",wwww}"

"{"title=\"dit is een title tekst\"","title=\"dit is een title tekst\"","dit
is een title tekst",NULL,NULL,NULL}"

 

I would like to have 1 row which contains both the records. Does anyone know
how I can solve this?

 

 

Willem 

  _____  

Van: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] Namens WP Perquin
Verzonden: dinsdag 12 mei 2009 13:44
Aan: pgsql-general@postgresql.org
Onderwerp: [GENERAL] regexp_matches problem

 

(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