Re: strange sql issue

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