Received: from trends.net (root@clio.trends.ca [209.47.148.2]) by hub.org
	(8.8.8/8.7.5) with ESMTP id GAA19917 for
	<pgsql-hackers@PostgreSQL.org>; Fri, 3 Jul 1998 06:19:29 -0400 (EDT)
Received: from proxy.bazzanese.com (root@c-bo5-119.tin.it [212.216.134.246])
	by trends.net (8.8.8/8.8.8) with ESMTP id GAA02141
	for <pgsql-hackers@PostgreSQL.org>; Fri, 3 Jul 1998 06:15:15 -0400 (EDT)
Received: from mbox.bazzanese.com (blu.bazzanese.com [10.20.30.12])
	by proxy.bazzanese.com (8.8.8/8.8.8/Debian/GNU) with SMTP id LAA00753
	for <pgsql-hackers@PostgreSQL.org>; Fri, 3 Jul 1998 11:53:45 GMT
Date: Fri, 3 Jul 1998 12:02:13 +0200
From: Sferacarta Software <sferac@bo.nettuno.it>
X-Mailer: The Bat! (v1.017) UNREG
Reply-To: Sferacarta Software <sferac@bo.nettuno.it>
Organization: Sferacarta Software
Priority: Normal
Message-ID: <17501.980703@bo.nettuno.it>
To: pgsql-hackers@PostgreSQL.org
Subject: Access & Postgres
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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