| From: | Alexander Klimov <ask(at)wisdom(dot)weizmann(dot)ac(dot)il> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | LO to text conversion |
| Date: | 2001-01-24 14:48:19 |
| Message-ID: | 3A6EEB33.6F8E6968@wisdom.weizmann.ac.il |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all.
I need to store XML documents in database, so I use large objects for
them. Now I have a problem: I want to search for patterns in documents,
and it looks like there is no standard way to do it, so I write
C function to do it, but it has limitation: it is not support regular
expressions. Although it will be easy to use some library to handel
them, but I know that PostgreSQL already has it.
So, my question is: is there any function to search in lobjs? Another
thing which would be enought is convertion of lo to text.
BTW: Somebody can say, that I could use text field for documents as
well, but it is inefficient to embed document in sql query and then
extract it back
--
Regards,
ASK
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mirko Zeibig | 2001-01-24 14:53:31 | Speed of varchar vs. char in indices |
| Previous Message | Bruce Momjian | 2001-01-24 14:45:02 | Re: [GENERAL] User names |