Alvaro Herrera <alvherre(at)atentus(dot)com> writes:
> [ in development sources ]
> SELECT foo1.mes, valor1999 AS "1999", valor2000 AS "2000" FROM
> (SELECT valor AS valor1999, mes FROM datos WHERE ao=1999) AS foo1
> INNER JOIN
> (SELECT valor AS valor2000, mes FROM datos WHERE ao=2000) AS foo2
> ON foo1.mes=foo2.mes;
> ERROR: flatten_join_alias_var: unexpected subtree type
I have committed changes to fix this bug. Thanks for the report!
regards, tom lane