pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedlo_tell
3+ messages / 2 participants
[nested] [flat]
* lo_tell
@ 1998-08-17 03:06 Christopher S. Weimann <cweimann@wallnet.com>
0 siblings, 1 reply; 3+ messages in thread
From: Christopher S. Weimann @ 1998-08-17 03:06 UTC (permalink / raw)
To: pgsql-interfaces
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
------------------------------------------------------------
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] lo_tell
@ 1998-08-17 09:40 Peter T Mount <peter@taer.maidstone.gov.uk>
parent: Christopher S. Weimann <cweimann@wallnet.com>
0 siblings, 1 reply; 3+ messages in thread
From: Peter T Mount @ 1998-08-17 09:40 UTC (permalink / raw)
To: Christopher S. Weimann <cweimann@wallnet.com>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] lo_tell
@ 1998-08-17 17:57 Christopher S. Weimann <cweimann@wallnet.com>
parent: Peter T Mount <peter@taer.maidstone.gov.uk>
0 siblings, 0 replies; 3+ messages in thread
From: Christopher S. Weimann @ 1998-08-17 17:57 UTC (permalink / raw)
To: pgsql-interfaces; peter@taer.maidstone.gov.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
------------------------------------------------------------
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1998-08-17 17:57 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-08-17 03:06 lo_tell Christopher S. Weimann <cweimann@wallnet.com>
1998-08-17 09:40 ` Peter T Mount <peter@taer.maidstone.gov.uk>
1998-08-17 17:57 ` Christopher S. Weimann <cweimann@wallnet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox