Postgres Pro
Downloads
Home   >   mailing lists

SELECTing part of a matrix - Mailing list pgsql-sql

From reina_ga@hotmail.com (Tony Reina)
Subject SELECTing part of a matrix
Date
Msg-id 272e4be7.0404271112.2f181266@posting.google.com
Whole thread Raw
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Kent L. Nasveschuk"
Date:
Subject: Re: Postgres as backend to Backup System
Next
From: Ray Jackson
Date:
Subject: date arithmetic over calender year boundaries