Which is faster? This...
SELECT t1.name
FROM t1, t2, t3, t4
WHERE
t1.id = 1 AND
t2.id = 2 AND
t3.id = 3 AND
t3.id = t4.id;
...or this...
SELECT t1.name
FROM t1, t2, t3, t4
WHERE
t1.id = 1 AND
t3.id = t4.id AND
t2.id = 2 AND
t3.id = 3;
Does it make a difference in pgsql?
Cheers,
Ed Loehr