That's a guess that doesn't really explain why it'd work under one OS
and not under another. Are the two versions of Postgres configured
the same?
I suppose they could be configured differently. I don't know how to
investigate this.
It isn't really a problem for me-- just strange.
culley
--
Culley,
> But on my production machine postgresql complained about the order by
> clause-- it wanted the table alias to be on last_name.
I believe this is because you used "u.last_name" earlier in the statement, and the
ORDER BY clause doesn't know that's what you mean.
That's a guess that doe