Last time I checked, implementing the join in the where clause like that just
gives the same results as an inner join. The old PostgreSQL 7.0 and earlier
docs had some other workarounds for making do without outer joins, but the
latest docs (7.1+) point out that outer joins are now fully supported, so
standard SQL syntax for these will work... as long as you're using Postgresql
7.1 or later.
Ian Summers <[EMAIL PROTECTED]> on 08/09/2001 07:11:19 AM
To: [EMAIL PROTECTED]
cc: (bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: Re: DBI::Pg avoiding OUTER JOIN
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
