Received: from tomts8-srv.bellnexxia.net (tomts8.bellnexxia.net [209.226.175.52]) by hub.org (8.10.1/8.11.0) with ESMTP id e9PFDWO77969 for ; Wed, 25 Oct 2000 11:13:32 -0400 (EDT) (envelope-from karkalis@earthling.net) Received: from killer ([64.229.48.150]) by tomts8-srv.bellnexxia.net (InterMail vM.4.01.03.00 201-229-121) with SMTP id <20001025151327.PDGJ625.tomts8-srv.bellnexxia.net@killer>; Wed, 25 Oct 2000 11:13:27 -0400 Message-ID: <020b01c03e96$674d2760$0382a8c0@metavera.com> From: "Tony Simopoulos" To: "Tom Lane" Cc: References: <1B3D5E532D18D311861A00600865478CF1B461@exchange1.nt.maidstone.gov.uk> <4983.972391441@sss.pgh.pa.us> Subject: Re: RE: JDBC now needs updates for large objects Date: Wed, 25 Oct 2000 11:15:26 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 X-Archive-Number: 200010/208 X-Sequence-Number: 1565 sorry, i must have missed something. when did outer join's start working? is there a patch that i can build? tonys. > That's a good thought. It'd be a useful practice to review such > standard queries from time to time anyway. For example, now that > outer joins work, a lot of psql's backslash-command queries could > be simplified (don't need the UNION ALL WITH SELECT NULL hack). > > Anyone have time to work up a list? > > regards, tom lane