Re: how to get size of array in function - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: how to get size of array in function
Date
Msg-id 20051128151100.GA1654@kaufbach.delug.de
Whole thread Raw
In response to how to get size of array in function  (Amit Soni <amit_soni@netcore.co.in>)
List pgsql-general
Amit Soni <amit_soni@netcore.co.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°

pgsql-general by date:

Previous
From: Franz.Rasper@izb.de
Date:
Subject: Re: PostgreSQL and SAN/NAS technologies
Next
From: Jerry LeVan
Date:
Subject: ANN: PgBrowse-1.3 is available.