use explicit JOINs can get around this ... check out this thread in
pgsql-sql:
http://archives.postgresql.org/pgsql-sql/2001-06/msg00318.php
I found it the other day as I had to remind myself how to do it :)
On Thu, 14 Feb 2002, david blood wrote:
> I thought I read somewhere but can't find it that the execution of the where
> clause statements in up to the optimizer. Is there a way to affect that?
>
>
> __________________________________________________
> Do You Yahoo!?
> Got something to say? Say it better with Yahoo! Video Mail
> http://mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>