Sandro Dentella <sandro(at)e-den(dot)it> writes:
> I only get films for which a vote was expressed. My query:
> SELECT f.id, f.titolo, p.voto
> FROM film_film f
> LEFT OUTER JOIN vota_punteggio p
> ON (f.id = p.film_id)
> WHERE
> (p.user_id = 2 OR p.user_id IS NULL)
> Can you help me understanding what is wrong?
[ scratches head... ] Looks all right to me. Are you sure you copied
what you typed accurately? Does EXPLAIN show that a left join is being
used?
regards, tom lane