Are arrays broken in 7.0.3?

From: Jason Aten <jaten(at)CS(dot)UCLA(dot)EDU>
To: pgsql-general(at)postgresql(dot)org
Subject: Are arrays broken in 7.0.3?
Date: 2000-12-18 21:24:45
Message-ID: Pine.SOL.4.10.10012181322430.27653-100000@panther.cs.ucla.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Can someone help me understay array usage in postgresql? After reading
the user manual (ch8), I tried to create a 2-d array of float8s...

and yet the database seems broken: when I ask for a row back I get
nothing!

Or, if I ask for a row another way, I get two rows! Please help!

Jason

p.s. how do you query the dimensionality of an n-dimensional array once it
is created?

postgresql 7.0.3 RPMs installed on Mandrake 7.1:
#rpm -qa | grep post
postgresql-python-7.0.3-2mdk
postgresql-devel-7.0.3-2mdk
postgresql-jdbc-7.0.3-2mdk
postgresql-7.0.3-2mdk
postgresql-tk-7.0.3-2mdk
postgresql-server-7.0.3-2mdk
postgresql-odbc-7.0.3-2mdk
postgresql-tcl-7.0.3-2mdk
postgresql-perl-7.0.3-2mdk
postgresql-test-7.0.3-2mdk

The following terminal session illustrates my concerns over arrays:

bash-2.04$ psql testdb
Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

testdb=# create table arr (
testdb(# f float8[][]);
CREATE
testdb=# insert into arr values ('{{1, 2, 3, 4,
5},{6,7,8,9,10},{11,12,13,14,15},{16,17,18,19,20}}');
INSERT 18953 1
testdb=# select * from arr;
f
------------------------------------------------------------------------------------------------------

{{"1","2","3","4","5"},{"6","7","8","9","10"},{"11","12","13","14","15"},{"16","17","18","19","20"}}
(1 row)

testdb=# select f[1] from arr; (ask for a row back - get nothing!)
f
---

(1 row)

testdb=# select f[1:2] from arr;
f
---

(1 row)

testdb=# select f[2] from arr;
f
---

(1 row)

testdb=# select f[2][1] from arr;
f
---
6
(1 row)

testdb=# select f[2][:] from arr;
ERROR: parser: parse error at or near "]"
testdb=# select f[2][1:5] from arr; (ask row back, get two!)
f
------------------------------------------------
{{"1","2","3","4","5"},{"6","7","8","9","10"}}
(1 row)

testdb=# select f[2][1:4] from arr;
f
---------------------------------------
{{"1","2","3","4"},{"6","7","8","9"}}
(1 row)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Feng Xue 2000-12-18 21:59:26 a "huge" table with small rows and culumns
Previous Message Tulio Oliveira 2000-12-18 21:12:20 Trigger running whith "postgres" superuser permission