When I run the following query through psql, it executes successfully. However, when I run it through ODBC (via OpenOffice Base), I get the error SQL Status: HY000 Error code: 1000 syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE Is this some limitation of ODBC? (I don't think so, so I'm going to ask on the OpenOffice lists, but thought I'd check here, too...) Query: select number_of_years, max(case when trial_id = 1 then period_results else null end) as MaxResults1, min(case when trial_id = 1 then period_results else null end) as MaxResults1, max(case when trial_id = 2 then period_results else null end) as MaxResults2, min(case when trial_id = 2 then period_results else null end) as MaxResults2 from trial_results where trial_id in (1,2) group by number_of_years order by number_of_years; This is on Linux, Fedora 8, using PostgreSQL 8.3.6 and unixODBC... Thanks for the help, Carl -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
