ODBC limitation??

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