Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

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

pgsql-interfaces by date

Next:From: Guy CorbazDate: 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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group