not translating a query properly. . . - Mailing list pgsql-interfaces

From JT Kirkpatrick
Subject not translating a query properly. . .
Date
Msg-id 01BE9308.0D3A5260.jt-kirkpatrick@mpsllc.com
Whole thread Raw
List pgsql-interfaces
here is my psqlodbc log -- it's short.  i have two problems (or may just
one).  it still shows using version 6.3, but i completely removed 6.3 (in
add/remove programs) and reinstalled 6.4.  the other problem i am having is
shown in it too -- i am in an access97 query sql view typing "select subnum
from subs union all select vnum from vend;" (which works great from the
psql prompt), but i am getting some kind of syntax error message.  if you
take the time to look into the file you'll also see another ongoing problem
i am having with booleans in my queries (where i am trying to show all
records that are 't' or =1 or any other way i try -- i just bombs).  is
there any reason why this query wouldn't run properly?  i thought upgrading
to the new version might help. . .

jt
Attachment

pgsql-interfaces by date:

Previous
From: Constantin Teodorescu
Date:
Subject: Re: [INTERFACES] pgaccess and autonumber fields.
Next
From: Michael J Davis
Date:
Subject: RE: [INTERFACES] not translating a query properly. . .