From: | "Richard Huxton" <dev(at)archonet(dot)com> |
---|---|
To: | "Alexander Klimov" <ask(at)wisdom(dot)weizmann(dot)ac(dot)il>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: LO to text conversion |
Date: | 2001-01-24 19:33:31 |
Message-ID: | 00e701c0863c$c3c68160$1001a8c0@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
----- Original Message -----
From: "Alexander Klimov" <ask(at)wisdom(dot)weizmann(dot)ac(dot)il>
> 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.
Don't think so - the objects are external to the DB. You could try 7.1 (in
beta at the moment) - that has TOAST to provide v.large text fields (seems
to work fine).
You might want to look at the full-text-index stuff in /contrib - something
based on that would probably be the way to go. Failing that, I know there
are some XML DBs out there somewhere. Presumably they are designed for this
sort of thing.
- Richard Huxton
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2001-01-24 19:34:46 | Re: Performance problem |
Previous Message | Bruce Momjian | 2001-01-24 19:31:29 | Re: [GENERAL] child table doesn't inherit PRIMARY KEY? |