David Hartwig <daveh@insightdist.com> writes:
> Both sort orders are correct. I seems that different machines are
> resolving equivalent strings differently. I got the same result as
> Tom on an RS/6000 box. I could be an big vs little endian, signed vs
> unsigned chars issue. In any case, the actual sort order is
> indeterminate. Therefore I will submit a new regression test with
> reliable test data.
OK.
> These results are also correct. Somewhat. I do not know much about
> datatime porting issues, but if I do a:
> SELECT d1 FROM DATETIME_TBL
> I get time reported to the 1/100 of a second. If GROUP BY d1 the
> hundredths are not shown. Thus, the counts and groupings are correct.
> Its just not showing the hundredths portion.
The issue here is why you (or whoever it was prepared the regression
test) got different results from me...
>>>> QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10);
>>>> ! ERROR: can't look up operator 713
>
> Don't know about this one.
That bug should be fixed in the current sources, I believe.
regards, tom lane