Received: from server1.wallnet.com (cweimann@server1.wallnet.com [208.225.162.8]) by hub.org (8.8.8/8.7.5) with ESMTP id XAA12195 for ; Sun, 16 Aug 1998 23:06:06 -0400 (EDT) Received: (from cweimann@localhost) by server1.wallnet.com (8.8.8/8.8.5) id XAA27398; Sun, 16 Aug 1998 23:06:04 -0400 (EDT) Message-ID: <19980816230603.16159@wallnet.com> Date: Sun, 16 Aug 1998 23:06:03 -0400 From: "Christopher S. Weimann" To: pgsql-interfaces@postgresql.org Subject: lo_tell Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.88 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 ------------------------------------------------------------