Hi all...one question..which sql syntax for joins will perform better on pgsql.. something like xxx OUTER JOIN yyy or SELECT xxx,yyy FROM bbb,ccc WHERE bbb.xxx = ccc.yyy ?? Are there any performance differences in executing these to queries in pg or will they be the same in means of time and resources?? I'm asking this because i'm tranferring an access97 db to postgres and i am using passthrough queries from access which are written as the first one i listed.. Thanks to all! ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
