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