Обсуждение: lo_tell
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? PS: If anyone has a suggestion for a better way to search on a large object I'd love to hear it. -- ------------------------------------------------------------ Christopher Weimann SysAdmin Wall Internet LLC. Email: cweimann@wallnet.com PO Box 255 Web: http://www.wallnet.com/~cweimann Manasquan NJ, 08736 732-223-1777 ------------------------------------------------------------
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
On Mon, Aug 17, 1998 at 10:40:11AM +0100, Peter T Mount wrote: > On Sun, 16 Aug 1998, Christopher S. Weimann wrote: > > > > 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). > Oops! I just checked and an int and a long are both 4 bytes so this turns out to have been stupid question. I know that ftell returns a long and figured that lo_tell should be the same. -- ------------------------------------------------------------ Christopher Weimann SysAdmin Wall Internet LLC. Email: cweimann@wallnet.com PO Box 255 Web: http://www.wallnet.com/~cweimann Manasquan NJ, 08736 732-223-1777 ------------------------------------------------------------