Hi Everybody, I am comparing selection results between postgres clusters on RHEL4 and Windows Server 2003.
The query is: select count(*)from schema.table where route < 'Interstate 12' on the RHEL machine the result has: 102 records on the windows machine the result has: 586 records the entire table has 687 records On both clusters the column route is of type character varying (40) On both clusters the server encoding is UTF8 - which I can see in pgAdminIII or by querying pg_database I would like to figure out if the locale on both clusters is the same, because if the locales are different that would explain the different result sets for the same query. Does anyone know how to check the locale of a cluster? The documentation has yielded this " You can check the LC_COLLATE and LC_CTYPE settings of a database with the contrib/pg_controldata utility program." I do not have a contrib folder on either machine, I suppose that I could go install it but is there an easier way? Thank you, Sincerely, Kasia -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
