Well, subselect in "from" was my first thought, too, but unlike Karl
Goldstein I knew that a) you were using Postgres and b) PG 7.0 doesn't
support subselects in "from" (PG 7.1 does, BTW, but it is pickier
about some error stuff that means that OpenACS doesn't run right out
of the box, our problem, not PG's).
So I didn't bother suggesting that solution. Nor did I suggest
building a view which returns the distinct rows, because PG 7.0
doesn't support "distinct" in views, either.
I'll look again at this tomorrow...do you have a web page we can look
at that shows the proper values unordered?
