Just got an email saying that this has been fixed in 8.3.4, so I suppose I'll watch and wait for that. Thanks for looking, Alan (and anyone else who was watching this...) Dave On Tue, Sep 9, 2008 at 4:57 PM, Alan Hodgson <ahodgson@xxxxxxxxx> wrote: > On Tuesday 09 September 2008, "David Jaquay" <djaquay@xxxxxxxxx> wrote: >> I'm seeing a problem with a LEFT JOIN in 8.3.3, running on what I >> believe to be an Ubuntu Heron server. The sql below demonstrates the >> issue. > > explain doesn't execute the query. Show the output of the actual select - it > doesn't return any rows on my 8.3.3 database. > > -- > Alan > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >