Re: [GENERAL] Counting elements of an array

2001-03-12 Thread Renaud Tthonnart
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]

Re: [GENERAL] Counting elements of an array

2001-03-12 Thread Renaud Tthonnart
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[] );

Re: [GENERAL] Counting elements of an array

2001-03-02 Thread Renaud Tthonnart
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]

[GENERAL] Counting elements of an array

2001-03-01 Thread Renaud Tthonnart
Good morning all, I would like to know how I can get the number of elements of an array. regards, Renaud THONNART

Re: [GENERAL] Counting elements of an array

2001-03-01 Thread Renaud Tthonnart
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;

Re: [GENERAL] Counting elements of an array

2001-03-01 Thread Tom Lane
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=#