Mur
06-04-02, 11:47
| This query returns different results under 7.1 and 7.2: select a from (select 'www.nytimes.com' as a union select 'www10.nytimes.com' as a ) as foo order by 1 Under 7.1, the results are: a ------------------- www10.nytimes.com www.nytimes.com (2 rows) While under 7.2, it's: a ------------------- www.nytimes.com www10.nytimes.com (2 rows) It appears to have something to do with the lengths of the strings, because if you change the literals in the query above to 'www.' and 'www1', the sort order is the same under either version. |