Date: Sun, 11 Jan 2004 21:04:54 -0700
From: Robert Creager <Robert_Creager@LogicalChaos.org>
To: PGSQL <pgsql-sql@postgresql.org>
Subject: Problem with NOT IN portion of query.
Message-Id: <20040111210454.4ee900ae.Robert_Creager@LogicalChaos.org>
Organization: Starlight Vision, LLC.
Mime-Version: 1.0
Content-Type: multipart/signed; protocol="application/pgp-signature";
	micalg="pgp-sha1";
	boundary="Multipart_Sun__11_Jan_2004_21_04_54_-0700_=.IJsd2ivWEfDDPk"

--Multipart_Sun__11_Jan_2004_21_04_54_-0700_=.IJsd2ivWEfDDPk
Content-Type: text/plain; charset=US-ASCII
Content-Disposition: inline
Content-Transfer-Encoding: 7bit


Hey All,

Probably doing something stupid, and I'm too tired to see what.  The query I'm
trying to execute is:

SELECT date_trunc( 'hour', "when" )::timestamp AS
period FROM readings WHERE period NOT IN (SELECT "time" FROM
hour.summary_period) GROUP BY period ORDER BY period;

Where the table definitions are:

CREATE TABLE readings ( "when" TIMESTAMP DEFAULT now() NOT NULL PRIMARY KEY );
CREATE SCHEMA hour;
CREATE TABLE hour.summary_period ( "time" TIMESTAMP NOT NULL );

The error is:

ERROR:  column "period" does not exist

When I remove the NOT IN (and associated WHERE), the query works fine.

Any help?

Cheers,
Rob

-- 
 20:55:35 up 14 days, 10:45,  4 users,  load average: 2.01, 2.04, 2.05

--Multipart_Sun__11_Jan_2004_21_04_54_-0700_=.IJsd2ivWEfDDPk
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iEYEARECAAYFAkACHOwACgkQLQ/DKuwDYzlKpgCbBYk3ZSRot461xlrxrj4hxHqw
0wAAnR5hL+Pif18vnGWGBjpJXndkp3eU
=aend
-----END PGP SIGNATURE-----

--Multipart_Sun__11_Jan_2004_21_04_54_-0700_=.IJsd2ivWEfDDPk--