using arrays as variable, not as field
I read the doc on
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=arrays.h
tml
These doc say you can use array_dims to get the dimension of an array.
But when I try to do some this
select array_dims('{1,2,3,4,5}');
I get this message:
ERROR: Cannot accept a constant of type ANYARRAY
I see several examples on "field" arrays, but I need to use a variable
with array type inside pl/pgsql (not inside a table), and I need to know
the length of this array. My instalation is 7.3.1.
Anybody have a tip about that?
Thanks in advance!
--
Fernando O. Papa
DBA
"Fernando Papa" <fpapa@claxson.com> writes:
These doc say you can use array_dims to get the dimension of an array.
But when I try to do some this
select array_dims('{1,2,3,4,5}');
I get this message:
ERROR: Cannot accept a constant of type ANYARRAY
That's not an array, it's just an untyped string. This works:
regression=# select array_dims('{1,2,3,4,5}'::int[]);
array_dims
------------
[1:5]
(1 row)
regards, tom lane
Ooops... thanks a lot Tom!!!
Maybe I need to read againt some chapters...
--
Fernando O. Papa
DBA
Show quoted text
-----Mensaje original-----
De: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Enviado el: jueves, 20 de marzo de 2003 13:57
Para: Fernando Papa
CC: pgsql-general
Asunto: Re: [GENERAL] using arrays as variable, not as field"Fernando Papa" <fpapa@claxson.com> writes:
These doc say you can use array_dims to get the dimension
of an array.
But when I try to do some this select array_dims('{1,2,3,4,5}');
I get this message:
ERROR: Cannot accept a constant of type ANYARRAYThat's not an array, it's just an untyped string. This works:
regression=# select array_dims('{1,2,3,4,5}'::int[]); array_dims
------------
[1:5]
(1 row)regards, tom lane
Import Notes
Resolved by subject fallback