Re: DBI::Pg avoiding OUTER JOIN

[Ian Summers]

Hi

>I understand that OUTER JOINS are not supported with the DBD::Pg driver..
>
>1) will it be supported any time soon ??
>2) if not, then what are some of the ways one would perform an outer join 
>in a cgi script using postgresql for a database ??

Try rephrasing the SQL without any joins at all. This can be done by 
putting the join ON statements into the WHERE clause.

SELECT * FROM table1,table2 WHERE table1.ID = table2.ID;

Ian