From: JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
To: 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org>
Subject: not translating a query properly. . .
Date: Fri, 30 Apr 1999 12:50:38 -0400
Message-ID: <01BE9308.0D3A5260.jt-kirkpatrick@mpsllc.com> (raw)
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
Attachments:
psqlodbc.log (application/octet-stream, 2.9K) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jt-kirkpatrick@mpsllc.com, pgsql-interfaces@hub.org
Subject: Re: not translating a query properly. . .
In-Reply-To: <01BE9308.0D3A5260.jt-kirkpatrick@mpsllc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox