X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 8E505D1B570
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 27 Apr 2004 16:14:39 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 68335-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 27 Apr 2004 16:14:38 -0300 (ADT)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by svr1.postgresql.org (Postfix) with ESMTP id 99B52D1B478
	for <pgsql-sql@postgresql.org>; Tue, 27 Apr 2004 16:14:36 -0300 (ADT)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by news.hub.org (8.12.9/8.12.9) with ESMTP id i3RJEaSx034159
	for <pgsql-sql@postgresql.org>; Tue, 27 Apr 2004 19:14:36 GMT
	(envelope-from news@news.hub.org)
Received: (from news@localhost)
	by news.hub.org (8.12.9/8.12.9/Submit) id i3RJCoVj033382
	for pgsql-sql@postgresql.org; Tue, 27 Apr 2004 19:12:50 GMT
From: reina_ga@hotmail.com (Tony Reina)
X-Newsgroups: comp.databases.postgresql.sql
Subject: SELECTing part of a matrix
Date: 27 Apr 2004 12:12:51 -0700
Organization: http://groups.google.com
Lines: 14
Message-ID: <272e4be7.0404271112.2f181266@posting.google.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Complaints-To: groups-abuse@google.com
To: pgsql-sql@postgresql.org
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200404/306
X-Sequence-Number: 17681

I've got a 3D matrix stored in a table. I'd like to pull back just 2
of the dimensions (specifying a constant value for the 3rd dimension).

e.g. 
table1
======
matrix1[5][10][20]

I've like to get matrix[1][all][all] and have it pulled back as a 2D
matrix (new_matrix1[all][all]).

Any way to do this?

-Tony