Max Khon <fjoe(at)iclub(dot)nsu(dot)ru> writes:
> test=# select a.id, b.id from a left join b using(id);
> id | id
> ----+----
> 43 |
> 45 |
> (2 rows)
> test=# select * from a;
> id
> ----
> 45
> 43
> 34
> (3 rows)
Ugh. It looks like mergejoin must be mishandling the first left-side
item when the right side is empty. Will take a look...
regards, tom lane