Re: [GENERAL] Howto determin the number of elemnts of an array

2005-01-31 Thread Együd Csaba
riginal Message- From: PFC [mailto:[EMAIL PROTECTED] Sent: Monday, January 31, 2005 8:48 PM To: Együd Csaba; 'Sven Willenberger'; pgsql-general@postgresql.org Subject: Re: [GENERAL] Howto determin the number of elemnts of an array contrib/intarray On Mon, 31 Jan 2005 20

Re: [GENERAL] Howto determin the number of elemnts of an array

2005-01-31 Thread PFC
iginal Message- From: PFC [mailto:[EMAIL PROTECTED] Sent: Monday, January 31, 2005 5:16 PM To: Együd Csaba; 'Sven Willenberger'; pgsql-general@postgresql.org Subject: Re: [GENERAL] Howto determin the number of elemnts of an array icount( array ) Hi Seven, it would be better for m

Re: [GENERAL] Howto determin the number of elemnts of an array

2005-01-31 Thread Együd Csaba
Csaba; 'Sven Willenberger'; pgsql-general@postgresql.org Subject: Re: [GENERAL] Howto determin the number of elemnts of an array icount( array ) > Hi Seven, > it would be better for me if it returned the number of elements as an > integer even if the array is emp

Re: [GENERAL] Howto determin the number of elemnts of an array

2005-01-31 Thread PFC
Együd -Original Message- From: Sven Willenberger [mailto:[EMAIL PROTECTED] Sent: Monday, January 31, 2005 4:27 PM To: pgsql-general@postgresql.org Cc: Együd Csaba Subject: Re: [GENERAL] Howto determin the number of elemnts of an array Együd Csaba wrote: Hi, how can I determin the number of

Re: [GENERAL] Howto determin the number of elemnts of an array

2005-01-31 Thread Együd Csaba
Message- From: Sven Willenberger [mailto:[EMAIL PROTECTED] Sent: Monday, January 31, 2005 4:27 PM To: pgsql-general@postgresql.org Cc: Együd Csaba Subject: Re: [GENERAL] Howto determin the number of elemnts of an array Együd Csaba wrote: > Hi, > how can I determin the number of elements

Re: [GENERAL] Howto determin the number of elemnts of an array

2005-01-31 Thread Sven Willenberger
Együd Csaba wrote: Hi, how can I determin the number of elements of an array? I saw function array_dims() which returns a string value representing the dimensions of the array. Is there a function which returns only the number of elements as an integer. -- Csaba array_upper(arrayname,dimension)