>So the first query will first produce
> >
> > a_val | c_val
> >---+---
> > 1 | 1
> >
> >and the FULL JOIN will add a row for b_val=2 with NULL a_val.
> >
> >The second query will first produce
> >
> > a_val | b_val
> >---+---
> > 1 | 1
> > 2 | 2
> > 3 |
> >
> >an since none but the first row matches a_val=1, you'll get only that row
> in the result.
> >
> >Yours,
> >Laurenz Albe
>
>
> Thank you!
>
> Sorry for not finding it myself, but now I understand why it behaves
> like this :-)
>
> Thanks
>
> Nicklas
>
--
Tim Rowe
ystem. I clicked on
> it from your email address just now. My work PC is running Windows 7.
> My email reader is the web based reader at mail.google.com. I'm using
> Google Chrome browser.
>
> On Wed, Mar 18, 2015 at 6:05 AM, Tim Rowe wrote:
> > Is the Windows graphical instal
Is the Windows graphical installer still available? The "download" link
from http://www.postgresql.org/download/windows/ gives a "Page not found"
error.
--
Tim Rowe