regexp_matches problem

From: "WP Perquin" <perquin(at)yuplounge(dot)nl>
To: <pgsql-general(at)postgresql(dot)org>
Subject: regexp_matches problem
Date: 2009-05-12 11:43:53
Message-ID: 8D4F705289524C3586CCAC88EE83BB99@yuploung008f4f
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

(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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message CM J 2009-05-12 11:55:26 Postgres BackUp and Restore: ERROR: duplicate key violates unique constraint "pg_largeobject_loid_pn_index"
Previous Message Albe Laurenz 2009-05-12 11:38:22 Re: Selecting data from bytea field in 8.3