Re: how to get size of array in function

From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: how to get size of array in function
Date: 2005-11-28 15:11:00
Message-ID: 20051128151100.GA1654@kaufbach.delug.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Amit Soni <amit_soni(at)netcore(dot)co(dot)in> schrieb:

> Hi list,
> i made one function and the argument of that function is string array,
>
> now how can i get the size of that array??

Please read
http://www.postgresql.org/docs/8.1/interactive/functions-array.html

You can use array_lower/array_upper or array_dims.

HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jerry LeVan 2005-11-28 15:24:33 ANN: PgBrowse-1.3 is available.
Previous Message Richard Huxton 2005-11-28 14:40:10 Re: Help with COPY Error: invalid UTF-8 byte ....