Search on a large object?

From: "Christopher S(dot) Weimann" <cweimann(at)wallnet(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Search on a large object?
Date: 1998-08-08 22:04:22
Message-ID: 19980808180422.38461@wallnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I am porting a web based forum cgi to PHP and PostgreSQL. My main
problem is that I need to use large objects to store the message
bodies since some of them exceed 8k. The existing forum software
allow searching on the bodies of the messages. I don't think I
can put the Oid of a large object in a WHERE and have do anything
useful :) I know that I could search the large objects with PHP
but that doesn't seem very efficient.

Searching a large object for a text string seems like something
that somebody must have done before but I can't find anything in
the archives about it. I think it is going to require something
in C to enable searching the LO in the WHERE.

I looked at MySql and it seems that its "large objects" can do this
but I'd rather not go that way.

Anybody have any suggestions for me?

--
------------------------------------------------------------
Christopher Weimann SysAdmin Wall Internet LLC.
Email: cweimann(at)wallnet(dot)com PO Box 255
Web: http://www.wallnet.com/~cweimann Manasquan NJ, 08736
732-223-1777
------------------------------------------------------------

In response to

  • vacuum at 1998-08-08 14:43:13 from Marcin Grondecki

Browse pgsql-general by date

  From Date Subject
Next Message Shawn T. Walker 1998-08-09 03:08:34 Re: [GENERAL] Postgres CGI Security Problem
Previous Message Maarten Boekhold 1998-08-08 20:51:26 Re: [GENERAL] Postgres CGI Security Problem