query works fine via ODBC on Windows and via the SQL Gui on both Linux and Windows against the same instance of Postgres 8.4 (running on Windows).
any suggestions?
postgres on linux "PostgreSQL 8.4.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-10), 32-bit" postgres on windows "PostgreSQL 8.4.1, compiled by Visual C++ build 1400, 32-bit"
[PG84] Description = PostgreSQL Driver = psqlODBC Database = test Servername = remotebox Username = test Password = test123$ Port = 5432 Protocol = 7.4 ReadOnly = No RowVersioning = No ShowSystemTables = No ShowOidColumn = No FakeOidIndex = No