Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <psycopg-owner+archive@lists.postgresql.org>)
	id 1m3m9e-0005ob-CG
	for psycopg@arkaria.postgresql.org; Wed, 14 Jul 2021 21:10:54 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <psycopg-owner+archive@lists.postgresql.org>)
	id 1m3m9c-0003IB-Gj
	for psycopg@arkaria.postgresql.org; Wed, 14 Jul 2021 21:10:52 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <rshepard@appl-ecosys.com>)
	id 1m3m9c-0003I3-BQ
	for psycopg@lists.postgresql.org; Wed, 14 Jul 2021 21:10:52 +0000
Received: from mail.appl-ecosys.com ([50.126.108.78])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <rshepard@appl-ecosys.com>)
	id 1m3m9Y-0005iK-S6
	for psycopg@postgresql.org; Wed, 14 Jul 2021 21:10:51 +0000
Received: from localhost.localdomain (localhost.localdomain [127.0.0.1])
	by mail.appl-ecosys.com (Postfix) with ESMTP id 2B82F2A0106
	for <psycopg@postgresql.org>; Wed, 14 Jul 2021 14:10:46 -0700 (PDT)
Date: Wed, 14 Jul 2021 14:10:46 -0700 (PDT)
From: Rich Shepard <rshepard@appl-ecosys.com>
To: psycopg@postgresql.org
Subject: Re: New user questions
In-Reply-To: <b030d87b-43d9-d994-7291-18a0caef0656@aklaver.com>
Message-ID: <alpine.LNX.2.20.2107141408210.28523@salmo.appl-ecosys.com>
References: <alpine.LNX.2.20.2107131228540.11509@salmo.appl-ecosys.com>
 <36d964b4-e04b-5fdf-9b21-d3bf80a3505d@aklaver.com>
 <alpine.LNX.2.20.2107131457030.11509@salmo.appl-ecosys.com>
 <9b477722-71af-abbb-8db7-1390a9906b07@aklaver.com>
 <alpine.LNX.2.20.2107141029300.12992@salmo.appl-ecosys.com>
 <b030d87b-43d9-d994-7291-18a0caef0656@aklaver.com>
User-Agent: Alpine 2.20 (LNX 67 2015-01-07)
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset=US-ASCII
List-Id: <psycopg.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:psycopg@lists.postgresql.org>
List-Owner: <mailto:psycopg-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/psycopg>
Archived-At: 
 <https://www.postgresql.org/message-id/alpine.LNX.2.20.2107141408210.28523%40salmo.appl-ecosys.com>
Precedence: bulk

On Wed, 14 Jul 2021, Adrian Klaver wrote:

> Where are c.nbr and a.* coming from? If they are supposed to be table
> qualified values this will not work.

Adrian,