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

Re: [HACKERS] Access & Postgres

From: David Hartwig <daveh(at)insightdist(dot)com>
To: Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it>, pgsql-interfaces <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] Access & Postgres
Date: 1998-07-06 20:30:19
Message-ID: (view raw or whole thread)
Lists: pgsql-hackerspgsql-interfaces
This question may be better posted on the interfaces list.

Visit the FAQ.   It is one of the last items listed.

Sferacarta Software wrote:

> 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

In response to


pgsql-hackers by date

Next:From: Tom LaneDate: 1998-07-06 22:18:49
Subject: Which signal to use for CANCEL from postmaster to backend?
Previous:From: Tom LaneDate: 1998-07-06 20:02:25
Subject: New s_lock.h fails on HPUX with gcc

pgsql-interfaces by date

Next:From: Bruce TaylorDate: 1998-07-07 06:53:08
Subject: A fast, cheap database-backed Web server
Previous:From: Elaine ArajoDate: 1998-07-06 20:10:06
Subject: PostgreSql-users and passwords

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