Re: RFE: Use JOIN instead of WHERE in Graphical Query Builder

From: "Nelson A(dot) de Oliveira" <naoliv(at)gmail(dot)com>
To: "Daniel Serodio (lists)" <daniel(dot)lists(at)mandic(dot)com(dot)br>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: RFE: Use JOIN instead of WHERE in Graphical Query Builder
Date: 2012-07-17 22:40:07
Message-ID: CAARFvTVj8tmZn+SiYCqYodEwey1wpfKfY0RvEHsU1PfgPeCupA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi!

On Tue, Jul 17, 2012 at 7:36 PM, Daniel Serodio (lists)
<daniel(dot)lists(at)mandic(dot)com(dot)br> wrote:
> I'm using pgAdmin 1.14.3, and its Graphical Query Builder generates WHERE
> clauses for joins. It would be nice if it generated JOIN clauses instead.

Is there any kind of difference between WHERE or JOINs in PostgreSQL?
Aren't they all a cartesian product internally?

Best regards,
Nelson

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Daniel Serodio (lists) 2012-07-17 23:06:17 Re: RFE: Use JOIN instead of WHERE in Graphical Query Builder
Previous Message Daniel Serodio (lists) 2012-07-17 22:36:55 RFE: Use JOIN instead of WHERE in Graphical Query Builder