Perhaps a more recent version of postgres (8.1 or mayber even look at 8.2 ...); lots of improvements since 7.1, IIRC in the area of joins specifically, but I don't know the answer to your question specifically. HTH, Greg Williamson (a [mostly] former Informix user, but not, alas, with such queries) DBA GlobeXplorer LLC -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx on behalf of H.J. Sanders Sent: Wed 11/8/2006 4:27 AM To: Martijn van Oosterhout; pgsql-general@xxxxxxxxxxxxxx Cc: Subject: Re: [GENERAL] converting Informix outer to Postgres Hi.