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

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

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=#

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

[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