From: | Carl Sopchak <carl(dot)sopchak(at)cegis123(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | ODBC limitation?? |
Date: | 2009-03-15 00:40:40 |
Message-ID: | 200903142040.40789.carl.sopchak@cegis123.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Marco Colombo | 2009-03-15 00:48:35 | Re: Maximum transaction rate |
Previous Message | Christophe | 2009-03-14 22:27:19 | Video from the 2009-03-11 SFPUG talk on Unison, by Reese Hart |