Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1])
	by hub.org (8.9.1/8.9.1) with ESMTP id FAA07289
	for <pgsql-interfaces@postgresql.org>;
	Fri, 27 Nov 1998 05:30:42 -0500 (EST)
	(envelope-from jose@sferacarta.com)
Received: from proxy.sferacarta.com (mail@sfcabop1.nettuno.it
 [193.207.10.213])
	by bologna.nettuno.it (8.8.6/8.8.6/NETTuno 3.1) with ESMTP id LAA18678;
	Fri, 27 Nov 1998 11:30:20 +0100 (MET)
Received: from rosso.sferacarta.com (sferacarta.com) [10.20.30.5]
	by proxy.sferacarta.com with esmtp (Exim 2.05 #1 (Debian))
	id 0zjMuT-00022c-00; Fri, 27 Nov 1998 12:22:05 +0000
Message-ID: <365E7E56.4E3C1C4C@sferacarta.com>
Date: Fri, 27 Nov 1998 11:26:30 +0100
From: "Jose' Soares" <jose@sferacarta.com>
Reply-To: sferac@bo.nettuno.it
Organization: Sfera Carta Software
X-Mailer: Mozilla 4.05 [en] (Win95; I)
MIME-Version: 1.0
To: daveh@insightdist.com
CC: byronn@insightdist.com, pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: psqlodbc
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi David and Byron,

I have another problem with psqlodbc using m$access.
I have the following query:

SELECT azienda, attivita, specifica, inizio_attivita, fine_attivita
FROM ATTIVITA WHERE attivita<='10'
UNION ALL
SELECT azienda, attivita, specifica, inizio_attivita, fine_attivita
FROM figure
INNER JOIN attivita ON figure.codice_figura = attivita.azienda
WHERE figure.tipo='A';

Seems that psqlodbc translate it in a wrong way because it enclose
SELECTS between () and PostgreSQL doesn't understands (SELECT ....):
Here the log file:
-------------------------------------------------------------------
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while
executi
ng the query'
                
------------------------------------------------------------
                 hdbc=54067320, stmt=54081812, result=0
                 manual_result=0, prepare=0, internal=0
                 bindings=0, bindings_allocated=0
                 parameters=0, parameters_allocated=0
                 statement_type=-1, statement='(SELECT "azienda"
,"attivita" ,"s
pecifica" ,"inizio_attivita" ,"fine_attivita"  FROM "attivita" WHERE
("attivita"
 <= '10' ) ) UNION ALL (SELECT "attivita"."azienda"
,"attivita"."attivita" ,"att
ivita"."specifica" ,"attivita"."inizio_attivita"
,"attivita"."fine_attivita"  FR
OM "figure","attivita" WHERE (("figure"."tipo" = 'A' ) AND
("figure"."codice_fig
ura" = "attivita"."azienda" ) ) )'
                 stmt_with_params=''
                 data_at_exec=-1, current_exec_param=-1, put_data=0
                 currTuple=-1, current_col=-1, lobj_fd=-1
                 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,
scroll_
concurrency=1
                 cursor_name='SQL_CUR03393914'
-----------------------------------------------------------------------

Thanks for any help

-Jose'-