Re: CTE or Subselect and outer joins not behaving as expected? - Mailing list pgsql-sql

Ah, yes!  Thanks for the help.

On Oct 25, 2011, at 5:42 AM, Harald Fuchs wrote:

> Joel Stevenson <jstevenson@bepress.com> writes:
>
> Your WHERE clause turns the OUTER into an INNER JOIN.  Try
>
> select tally_table.tally_mon, met.datum
> from (
>   select distinct date_trunc( 'month', '2011-06-01'::date + tally_day )::date as tally_mon
>   from generate_series( 0, ( select current_date - '2011-06-01'::date ) ) as tally_day
> ) as tally_table
> left join my_existing_table as met on tally_mon = met.month and met.series = 1;