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)
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 |