Re: [GENERAL] Different result depending on order of joins

2015-05-22 Thread Tim Rowe
>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

Re: [GENERAL] Windows installer

2015-03-18 Thread 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

[GENERAL] Windows installer

2015-03-18 Thread Tim Rowe
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