Re: Outer Joins

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Robert B(dot) Easter" <reaster(at)comptechnews(dot)com>
Cc: "Poul L(dot) Christiansen" <poulc(at)cs(dot)auc(dot)dk>, Michael Dunn <michael(at)2cactus(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Outer Joins
Date: 2001-01-07 17:29:19
Message-ID: 2052.978888559@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Robert B. Easter" <reaster(at)comptechnews(dot)com> writes:
> Just for the heck of it, I tried to execute all this sql on 7.0.3 and got
> this:
> psql:join2.sql:23: pqReadData() -- backend closed the channel unexpectedly.
> I knew it wouldn't run it, but didn't think it would crash.

7.0 had the beginnings of parser support for JOIN syntax, but there
were bugs ... I think the one that you hit had to do with nested JOIN
clauses, ie, a JOIN b JOIN c.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-01-07 17:44:13 Re: Problems with order by, limit, and indices
Previous Message Radoslaw Stachowiak 2001-01-07 16:41:45 Re: cyrillic and sort order (ORDER BY)