Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5CGYbE41740 for ; Tue, 12 Jun 2001 12:34:37 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f57CSgE86102 for ; Thu, 7 Jun 2001 08:28:42 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f57CJf230708 for pgsql-sql@postgresql.org; Thu, 7 Jun 2001 08:19:41 -0400 (EDT) (envelope-from news) From: "fabrizio" X-Newsgroups: comp.databases.postgresql.sql Subject: which sql syntax is better for joins on pgsql? Date: Thu, 7 Jun 2001 14:22:05 +0200 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 13 Message-ID: <9fnrgq$tvg$1@news.tht.net> X-Complaints-To: scrappy@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 To: pgsql-sql@postgresql.org X-Archive-Number: 200106/181 X-Sequence-Number: 3410 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!