Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org
	(8.8.8/8.7.5) with ESMTP id MAA22532 for
	<pgsql-interfaces@postgreSQL.org>;
	Wed, 8 Jul 1998 12:14:43 -0400 (EDT)
Received: from insightdist.com (nobody@localhost)
	by u1.abs.net (8.9.0/8.9.0) with UUCP id MAA18228
	for pgsql-interfaces@postgreSQL.org;
	Wed, 8 Jul 1998 12:14:12 -0400 (EDT)
X-Authentication-Warning: u1.abs.net: nobody set sender to
	insightdist.com!daveh using -f
Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03)
	id AA31510; Wed, 8 Jul 1998 11:55:52 -0400
Received: from daveh by ceodev (AIX 4.1/UCB 5.64/4.03)
	id AA30204; Wed, 8 Jul 1998 11:55:51 -0400
Message-Id: <35A397BC.227963C7@insightdist.com>
Date: Wed, 08 Jul 1998 12:01:01 -0400
From: David Hartwig <daveh@insightdist.com>
Organization: Insight Distribution Systems
X-Mailer: Mozilla 4.05 [en] (Win95; I)
Mime-Version: 1.0
To: Sferacarta Software <sferac@bo.nettuno.it>,
	pgsql-interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: [HACKERS] Access & Postgres
References: <35A133DB.CFE63868@insightdist.com> <17439.980708@bo.nettuno.it>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

The backend patch is downloadable text file, linked to our FAQ.   I think the direct URL is
http://www.insightdist.com/psqlodbc/junkfilter_patch.txt

I know the code works.   Let me know, though,  if you have trouble retrieving or applying it.   The
patch was originally 2 patches.  I just cat'ed them together.   It should apply properly.

PS:  This is the first time I have distributed the patch this way.  So could I get an affirmation from
you even if it goes smoothy.

Sferacarta Software wrote:

> Hello David,
>
> Do you remember our problem with ORDER BY not in target list ?
> Well, seems that now we can't go on without your fix.
> Please may you send me it ?  Thanks
>
> luned́, 6 luglio 98, you wrote:
>
> DH> This question may be better posted on the interfaces list.
> DH> See:  http://www.insightdist.com/psqlodbc
> DH> Visit the FAQ.   It is one of the last items listed.
> H> Sferacarta Software wrote:
>
> >> Hi all,
> >> I have this problem:
> >>
> >> This sample query create with Access
> >>
> >> SELECT figure.*, utenti.ragione_sociale
> >> FROM figure INNER JOIN utenti ON figure.codice_figura = utenti.azienda;
> >>
> >> via-psqlODBC reports this
> >>
> >> ERROR:  The field being ordered by must appear in the target list'
> >> STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
> >>
> >> Postgres executes this sql query (I find this in Psqlodbc.log file) :
> >>
> >> SELECT figure.oid,utenti.azienda
> >> FROM utenti,figure WHERE (figure.codice_figura = utenti.azienda ) ORDER BY figure.codice_figura
> >>
> >> Why is there ORDER BY CLAUSE ?
> >> Why is there only "figure.oid" instead of "figure.*" in SELECT
> >> arguments ??????
> >>
> >> Best regards,
> >>  Marco Pollachini
> >>  Sferacarta                          mailto:sferac@bo.nettuno.it
>
> Best regards,
>  Jose'                                  mailto:sferac@bo.nettuno.it