Postgres Pro
Downloads
Home   >   mailing lists

Re: JOINing subselects in FROM? - Mailing list pgsql-general

From Tom Lane
Subject Re: JOINing subselects in FROM?
Date
Msg-id 11745.1020024223@sss.pgh.pa.us
Whole thread Raw
In response to JOINing subselects in FROM?  (Alvaro Herrera <alvherre@atentus.com>)
List pgsql-general
Tree view 
Alvaro Herrera <alvherre@atentus.com> writes:
> [ in development sources ]
> SELECT foo1.mes, valor1999 AS "1999", valor2000 AS "2000" FROM
>     (SELECT valor AS valor1999, mes FROM datos WHERE a�o=1999) AS foo1
>     INNER JOIN
>         (SELECT valor AS valor2000, mes FROM datos WHERE a�o=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

pgsql-general by date:

Previous
From: Ron Snyder
Date:
Subject: Re: How to track down inconsistent performance?
Next
From: Jean-Michel POURE
Date:
Subject: Re: Performance Issues