On Sun, 16 Aug 1998, Christopher S. Weimann wrote:
>
> I need to search a database for some text that is in a large object.
> It seems that there isn't a way to put a large object in a WHERE so
> I am trying to write a c function that will return the text stored
> in a large object so I can do a comparison in the WHERE.
>
>
> Anyway in the course of this I discoverd that lo_tell returns an
> int rather than a long. Is there a limitation to the size of a
> large object or just a limitation in lo_tell?
There shouldn't be a limit, except that the lo is stored in as a
table/index pair - and they are not tested much past 2Gb (not many of us
have larger than 2Gb spare to test it).
> PS: If anyone has a suggestion for a better way to search on a
> large object I'd love to hear it.
I'd bee interested to see if there are any better ways of performing
searches.
I claimed the TODO item for enabling the text type to use large objects,
and enabling searches is a must for it.
--
Peter Mount (at work) peter@taer.maidstone.gov.uk or peter@maidstone.gov.uk
If you mail me here, please cc my home address peter@retep.org.uk