From: Sferacarta Software <sferac@bo.nettuno.it>
To: pgsql-hackers@PostgreSQL.org
Subject: Access & Postgres
Date: Fri, 3 Jul 1998 12:02:13 +0200
Message-ID: <17501.980703@bo.nettuno.it> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: sferac@bo.nettuno.it, pgsql-hackers@PostgreSQL.org
Subject: Re: Access & Postgres
In-Reply-To: <17501.980703@bo.nettuno.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox