Re: [GENERAL] regexp_matches problem

2009-05-13 Thread WP Perquin
x27;ig' ) AS firstresult ) as secondresult This is it. Very simple and very efficient. It took me ages to find out. Hopefully it helps other people. Willem -Oorspronkelijk bericht- Van: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org

Re: [GENERAL] regexp_matches problem

2009-05-12 Thread WP Perquin
\"",}" "{"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 solv

[GENERAL] regexp_matches problem

2009-05-12 Thread WP Perquin
(postgresql 8.3.7, linux centos) I made the following regexp_matches SELECT regexp_matches( ( SELECT content FROM page WHERE idpage = 2 ) ,',']))*>' , 'ig' ) AS result The result looks like: {"\"",NULL,NULL,"\""} in phpPgAdmin. Which is not th