Thomas Peter writes: > the following sql stopped working with postgres, and the fix of this > problem seems strange to me. [...] > and the fix was, to twist the order in the FROM statement. > changing > FROM ticket as t, permission as perm, enum as p > to > FROM permission as perm, enum as p, ticket as t > works like expected! > > so is this a bug, or do i get soemthing wrong (a hint where to rtfm would > be very welcome in this case) If by "stopped working" you mean that the query returns an unexpected result set, there should be a difference in the respective query plans (explain analyze). Comparing them might give a clue what is going wrong. regards, andreas
