large document multiple regex

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "postgres general" <pgsql-general(at)postgresql(dot)org>
Subject: large document multiple regex
Date: 2007-01-26 14:06:50
Message-ID: b42b73150701260606m24e9957fsf66aeabfa98a1b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I am receiving a large (300k+_ document from an external agent and
need to reduce a few interesting bits of data out of the document on
an insert trigger into separate fields.

regex seems one way to handle this but is there any way to avoid
rescanning the document for each regex. One solution I am kicking
around is some C hackery but then I lose the expressive power of
regex. Ideally, I need to be able to scan some text and return a
comma delimited string of values extracted from it. Does anybody know
if this is possible or have any other suggestions?

merlin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2007-01-26 14:20:30 Re: [Fwd: [PORTS] M$ SQL server DTS package equivalent in Postgres]
Previous Message Dave Cramer 2007-01-26 14:00:52 Re: "no unpinned buffers available" ? why? (hstore and plperl involved)