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
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? |
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 |