Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3AB8B476256 for ; Wed, 1 Jan 2003 16:46:51 -0500 (EST) Received: from www.e-servicesystem.com (s64-180-126-48.bc.hsia.telus.net [64.180.126.48]) by postgresql.org (Postfix) with ESMTP id 8265D47627F for ; Wed, 1 Jan 2003 16:46:49 -0500 (EST) Received: from power (dmz_gw.e-servicesystem.com [192.168.147.3]) by www.e-servicesystem.com (8.11.2/8.11.2) with ESMTP id h01NJUY11985 for ; Wed, 1 Jan 2003 15:19:30 -0800 Content-Type: text/plain; charset="gb2312" From: Daniel Bruce Lynes To: pgsql-sql@postgresql.org Subject: Internal functions documented Date: Wed, 1 Jan 2003 13:54:40 -0800 X-Mailer: KMail [version 1.4] MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200301011354.40428.dlynes@shaw.ca> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/1 X-Sequence-Number: 10866 I've noticed a lot of the functions that are documented for libpg are also= =20 stored in pg_proc. Are these functions additionally callable from pl/pgsql= ?=20=20 And if so, are they documented for pl/pgsql anywhere, or do we need to make= =20 educated guesses as to the parameters for them under pl/pgsql? For instance, lo_lseek, lo_create, ... The reason I'm asking is because I would like to be able to do something=20 similar to Oracle's DBMS_LOB.getlength(), DBMS_LOB.copy(), DBMS_LOB.write()= ,=20 DBMS_LOB.read() under pl/pgsql, without having to resort to writing a store= d=20 procedure in C, if I can possibly avoid it (easier for porting concerns). Thanks.