Received: from hu.tm.ee (ppp868.tele2.ee [212.107.37.168]) by hub.org (8.9.3/8.9.3) with ESMTP id RAA07237; Thu, 3 Feb 2000 17:31:28 -0500 (EST) (envelope-from hannu@tm.ee) Received: from tm.ee (localhost [127.0.0.1]) by hu.tm.ee (Postfix) with ESMTP id 79E3E3987; Fri, 4 Feb 2000 00:38:28 +0200 (EET) Sender: hannu@hu.tm.ee Message-ID: <389A0364.A1E6E766@tm.ee> Date: Fri, 04 Feb 2000 00:38:28 +0200 From: Hannu Krosing Organization: Trust-O-Matic =?iso-8859-1?Q?O=DC?= X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13-7mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: Chris Cc: Tom Lane , pgsql-hackers@postgreSQL.org, pgsql-sql@postgreSQL.org Subject: Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL References: <3898DA32.793A98BA@nimrod.itg.telecom.com.au> <24649.949546519@sss.pgh.pa.us> <3898F8DE.8159BFE7@nimrod.itg.telecom.com.au> <389958FB.2E6927B5@tm.ee> <38995C95.38897035@bitmead.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Chris wrote: > > Hannu Krosing wrote: > > > Maybe SELECT ** FROM BASE would be more flexible as it leaves the standard > > SQL with its "standard" meaning ? > > That was my first thought and it's definitely a possibility. My argument > against it is that SQL doesn't have a "standard meaning" in the case of > inheritance, and ** is an incompatibility with OQL. > > I suspect we need both. Something like > SET GET_INHERITED_COLUMNS true; etc. > > > We will have to change the API sometime not too distant anyway, the current > > api is unable to deal with anything that does not have a nice textual > > representation (like an image or sound) in spite of all the talks about > > easy extensibility - the extensibility is all in the backend, ther is no > > easy way to get new datatypes in/out. > > What about PQbinaryTuples() and friends? They don't help you at all when doing inserts and are by definition in native byte order on queries. Something like [ PREPARE query; BIND arguments ; EXEC ] which knows about binary formats would be needed here. One could use LOs except that the current ineffective implementation. ------------- Hannu