DeJuan Jackson wrote:
I have a suspicion that the version might be different. I have the same
symptom here on two different RH 7.3 boxes one running 7.3.2 and the
other running 7.3.3
It would appear 7.3.2 is more strict about the naming of the GROUP BY
fields.
They really are the same version
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
