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(at)bo(dot)nettuno(dot)it

Responses

• Re: [HACKERS] Access & Postgres at 1998-07-06 20:30:19 from David Hartwig

pgsql-hackers by date

Next:	From: Stupor Genius	Date: 1998-07-03 14:49:51
	Subject: RE: [HACKERS] implementing outer joins
Previous:	From: David Wetzel	Date: 1998-07-03 09:28:08
	Subject: are BLOBs deleted that are not referenced?

pgsql-interfaces by date

Next:	From: Guy Corbaz	Date: 1998-07-03 11:48:55
	Subject: ODBC connection refused
Previous:	From: Abraham Licayan Jr.	Date: 1998-07-03 07:47:39
	Subject: error 3073