Postgres Pro
Downloads
Home   >   mailing lists

Re: explicit joins wrong planning - Mailing list pgsql-sql

From Tom Lane
Subject Re: explicit joins wrong planning
Date
Msg-id 296.1070049123@sss.pgh.pa.us
Whole thread Raw
In response to Re: explicit joins wrong planning  (Tomasz Myrta <jasiek@klaster.net>)
Responses Re: explicit joins wrong planning  (Tomasz Myrta <jasiek@klaster.net>)
List pgsql-sql
Tree view 
Tomasz Myrta <jasiek@klaster.net> writes:
> If I add "and k.id_trasy=lt.id_trasy" into where clause (duplicate), the 
> query works fine.

Define "works fine", please (again, EXPLAIN ANALYZE would be a nice
concrete description).
        regards, tom lane

pgsql-sql by date:

Previous
From: Tomasz Myrta
Date:
Subject: Re: explicit joins wrong planning
Next
From: "Randolf Richardson, DevNet SysOp 29"
Date:
Subject: Re: SQL a simple menu - plz help