Access & Postgres

From: Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it>
To: pgsql-hackers(at)PostgreSQL(dot)org
Subject: Access & Postgres
Date: 1998-07-03 10:02:13
Message-ID: 17501.980703@bo.nettuno.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-interfaces

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

Browse pgsql-hackers by date

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

Browse pgsql-interfaces by date

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