Re: [SQL] Postgresql quey planner

2006-10-05 Thread Tom Lane
"=?ISO-8859-1?Q?William_Leite_Ara=FAjo?=" <[EMAIL PROTECTED]> writes: > The second does really what I desire. Show all records in table > "posto", including that's without count in table "autuados". But the first, > doesn't. Some elements on table "Posto" are ommited. What PG version is this?

[SQL] Postgresql quey planner

2006-10-05 Thread William Leite Araújo
  Estou confuso com o funcionamento do "query planner" do postgresql. Tenho 2 queries conceitualmente idênticas:  I'm confused about the planner functionality. I'd 2 queries contextualy indentical: SELECT p.pos_id, count(aut_id) as pesadosFROM posto p LEFT OUTER JOIN pesagem e USING(pos_id