On Mon, Aug 01, 2011 at 10:53:16PM +0300, Johnny Edge wrote:
> Hi folks,
>
> I have a problem with identical versions of postgresql - 8.3.13
>
> Config files are identical. HostA is a 32 bit CentOS 5.3 install and the
> hostB is x86_64 CentOS 6.
>
> Difference in architecture should not be a problem - I have another 64
> bit CentOS where both queries are executed displaying identical results.
It's probably locale related. Postgres uses the same order as the
"sort" command.
Try "show lc_collate".
Hope this helps,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> He who writes carelessly confesses thereby at the very outset that he does
> not attach much importance to his own thoughts.
-- Arthur Schopenhauer