SELECTing part of a matrix

From: reina_ga(at)hotmail(dot)com (Tony Reina)
To: pgsql-sql(at)postgresql(dot)org
Subject: SELECTing part of a matrix
Date: 2004-04-27 19:12:51
Message-ID: 272e4be7.0404271112.2f181266@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Ray Jackson 2004-04-28 04:12:34 date arithmetic over calender year boundaries
Previous Message Kent L. Nasveschuk 2004-04-27 18:59:12 Re: [SQL] Postgres as backend to Backup System