toruvinn <[EMAIL PROTECTED]> writes:
> The thing is, for some reason 8.3.3 doesn't correctly (left outer) join
> the tables when an additional condition in WHERE clause is supplied.
The patch for this is practically a one-liner, if you need it right
away:
http://archives.postgresql.org/pgsql-co
toruvinn <[EMAIL PROTECTED]> writes:
> toruvinn=> EXPLAIN ANALYZE SELECT
> i.id, i.albumid, i.userid,
> a.id as aid, a.visible_for AS al_visible_for, i.visible_for
> FROM items i
> LEFT OUTER JOIN albums a ON a.id=i.albumid
> WHERE i.userid=564667
> AND ((a.id IS NULL AND (i.visible_for IN (0,1)))
Hello.
I've asked on IRC about that and I was told to send mail to this maillist
about the problem I've encountered in postgresql 8.3.3 (well, actually my
friend found it).
The thing is, for some reason 8.3.3 doesn't correctly (left outer) join
the tables when an additional condition in WHE
