"=?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?
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