Tom Lane wrote:
Renaud Tthonnart [EMAIL PROTECTED] writes:
I would like to know how I can get the number of elements of an array.
There is a function that returns an array's dimensions as a text string:
regression=# select array_dims( '{1,2,3}'::int[] );
array_dims
[1:3]
Sorry!!
It works very well!
Renaud THONNART
Renaud Tthonnart [EMAIL PROTECTED] writes:
I would like to know how I can get the number of elements of an array.
There is a function that returns an array's dimensions as a text string:
regression=# select array_dims( '{1,2,3}'::int[] );
Tom Lane wrote:
Renaud Tthonnart [EMAIL PROTECTED] writes:
I would like to know how I can get the number of elements of an array.
There is a function that returns an array's dimensions as a text string:
regression=# select array_dims( '{1,2,3}'::int[] );
array_dims
[1:3]
Good morning all,
I would like to know how I can get the number of elements of an array.
regards,
Renaud THONNART
Christopher Sawtell wrote:
On Thu, 01 Mar 2001 21:53, you wrote:
Good morning all,
I would like to know how I can get the number of elements of an array.
create function array_element_count(_int4) returns integer as '
declare
a alias for $1;
i integer;
begin
i := 1;
Renaud Tthonnart [EMAIL PROTECTED] writes:
I would like to know how I can get the number of elements of an array.
There is a function that returns an array's dimensions as a text string:
regression=# select array_dims( '{1,2,3}'::int[] );
array_dims
[1:3]
(1 row)
regression=#