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

2015-05-22 Thread John McKown
Start here: http://www.postgresql.org/community/lists/subscribe/ Change the drop down from SUBSCRIBE to UNSUBSCRIBE and put in the rest of the required information. On Fri, May 22, 2015 at 8:06 AM, Tim Rowe wrote: > Sorry to post this on the list, but I can't find any way of unsubscribing > -- I

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

2015-05-22 Thread Christofer C. Bell
Tim, You just need to go back to the mailing list page on the PostgreSQL website: * Mailing list page: http://www.postgresql.org/list/ * Management page for subscriptions: http://www.postgresql.org/community/lists/subscribe/ While that URL says "subscribe", on the page itself, there's a drop-dow

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

2015-05-22 Thread Tim Rowe
Sorry to post this on the list, but I can't find any way of unsubscribing -- I've looked in messages, on the community home pages and on a web search, but all I find is a lot of other subscribers with the same problem. How do I unsubscribe from this list, please? On 22 May 2015 at 11:46, Nicklas

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

2015-05-22 Thread Nicklas Av�n
2015-05-22 skrev Albe Laurenz : Nicklas Avén wrote: >> I was a little surprised by this behavior. >> Is this what is supposed to happen? >> >> This query returns what I want: >> >> with >> a as (select generate_series(1,3) a_val) >> ,b as (select generate_series(1,2) b_val) >> ,c as (select ge

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

2015-05-22 Thread Albe Laurenz
Nicklas Avén wrote: > I was a little surprised by this behavior. > Is this what is supposed to happen? > > This query returns what I want: > > with > a as (select generate_series(1,3) a_val) > ,b as (select generate_series(1,2) b_val) > ,c as (select generate_series(1,1) c_val) > select * from a

[GENERAL] Different result depending on order of joins

2015-05-22 Thread Nicklas Avén
Hallo I was a little surprised by this behavior. Is this what is supposed to happen? This query returns what I want: with a as (select generate_series(1,3) a_val) ,b as (select generate_series(1,2) b_val) ,c as (select generate_series(1,1) c_val) select * from a inner join c on a.a_val=c.c