Re: LEFT OUTER JOIN problem

On Fri, 21 Sep 2001, Ludek Finstrle wrote:

> Hello,
>
> I have this problem (maybe only in my head ;o)):
>
> table1:
> -------
> id | name
> ---------
> 1 | 'blabla'
> 2 | 'arrrgh'
>
> table2:
> -------
> id | table1_id | name
> ---------------------
> 1 | 1 | 'hello'
>
> table3:
> -------
> id | table2_id | name
> ---------------------
>
> SELECT * FROM table1 LEFT OUTER JOIN table2 ON (table1.id = table2.table1_id)
> LEFT OUTER JOIN table3 ON (table2.id = table3.table2_id);
>
> This select return me only one row:
> 1,'blabla',1,1,'hello',NULL,NULL,NULL
>
> But I think it may return two rows:
> 1,'blabla',1,1,'hello',NULL,NULL,NULL
> 2,'arrrgh',NULL,NULL,NULL,NULL,NULL,NULL
>
> Where is the problem (in my head or in postgres)? Do you know what select
> statement return me what I want?

What version are you using? On 7.2 devel I get the two row result.