] Namens Albe Laurenz
Verzonden: woensdag 13 mei 2009 10:50
Aan: WP Perquin *EXTERN*; pgsql-general@postgresql.org
Onderwerp: Re: [GENERAL] regexp_matches problem
WP Perquin wrote:
> When I make the following simplified example:
>
> SELECT regexp_matches(''
>
> ,'((title\s*=
WP Perquin wrote:
> When I make the following simplified example:
>
> SELECT regexp_matches(''
>
> ,'((title\s*=\s*\"([^"]*)")+)|((src\s*=\s*\"([^"]*)")+)','ig')
>
> My result are 2 rows:
>
> "{NULL,NULL,NULL,"src=\"\"","src=\"\"",}"
>
> "{"title=\"dit is een title tekst\"","title=
e 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
(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
