Received: from pc63.meskes.de (root@as11-asy105.rp-plus.de [149.221.93.233]) by hub.org (8.9.2/8.9.1) with ESMTP id OAA43554 for ; Mon, 1 Mar 1999 14:30:46 -0500 (EST) (envelope-from Michael.Meskes@gmx.net) Received: (from meskes@localhost) by pc63.meskes.de (8.9.3/8.9.3/Debian/GNU) id UAA00851 for pgsql-interfaces@postgreSQL.org; Mon, 1 Mar 1999 20:01:14 +0100 Date: Mon, 1 Mar 1999 20:01:14 +0100 From: Michael Meskes To: PostgreSQL Interfaces Subject: Re: [INTERFACES] SQLDA Message-ID: <19990301200114.B833@gmx.net> Mail-Followup-To: PostgreSQL Interfaces References: <19990223204537.A246@gmx.net> <36DAC925.99702276@alumni.caltech.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.3i In-Reply-To: <36DAC925.99702276@alumni.caltech.edu>; from Thomas G. Lockhart on Mon, Mar 01, 1999 at 05:06:45PM +0000 On Mon, Mar 01, 1999 at 05:06:45PM +0000, Thomas G. Lockhart wrote: > SQL92 has a standard for SQLDAs, though they are not called that in the > standard. "A Guide to the SQL Standard" by Date and Darwen discusses the > SQL92 version of SQLDAs, and points out that: > > "... several SQL products do already support some kind of SQLDA, and > even refer to it by that name, but those SQLDAs are typically not the > same as the 'SQLDA' defined in the standard. In particular, the standard > SQLDA is encapsulated (meaning that its internal structure is not > specified in the standard and is thus a fortiori hidden from the user), > whereas the same is typically not true of the SQLDAs in current > products." That's okay with me. Could we even use the PGresult structure as SQLDA? > They also point out that the standard includes facilities for allocating > SQL DA storage and provides mechanisms for moving data in and out of SQL > DAs. I wonder where to find this standard. Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: (+49) 2431/72651 | Use Debian GNU/Linux! Email: Michael.Meskes@gmx.net | Use PostgreSQL!