[GENERAL] Array problem

2008-06-26 Thread Panagiotis Papadakos
Hi everybody. I have created a table containing an array of points (each point exists only once in the array). CREATE TABLE lala (id INT NOT NULL, occur point[] not NULL, PRIMARY KEY(id)); I am trying to find a way to get the position of array elements that have a specific x coordinate. Ho

Re: [GENERAL] Array Problem

2000-11-01 Thread Stephan Szabo
On Wed, 1 Nov 2000, John Burski wrote: > I'm working with version 6.5.2 and I've created a test table that > contains both a one and a two dimensional array. > > CREATE TABLE testa ( > name text, > links int2[], > vals int2[][] ); > > I'v populated the table with at least on

[GENERAL] Array Problem

2000-11-01 Thread John Burski
I'm working with version 6.5.2 and I've created a test table that contains both a one and a two dimensional array. CREATE TABLE testa ( name text, links int2[], vals int2[][] ); I'v populated the table with at least one record, so I should be able run 'select' requests that d