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 <klep...@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
signature.asc
Description: Digital signature
