using arrays as variable, not as field

Поиск
Список
Период
Сортировка
От Fernando Papa
Тема using arrays as variable, not as field
Дата
Msg-id F1DC5B511E2D1C499E5E20FC6D74160D01D6D6EF@exch2000.buehuergo.corp.claxson.com
обсуждение исходный текст
Ответы Re: using arrays as variable, not as field  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Dennis Gearon
Дата:
Сообщение: Re: PostgreSQL downloads compressed with bzip2 instead
Следующее
От: Doug McNaught
Дата:
Сообщение: Re: Handling Blobs with libpq