On Tue, Jul 21, 2009 at 10:47 AM, Sam Mason<sam(at)samason(dot)me(dot)uk> wrote:
> On Tue, Jul 21, 2009 at 04:08:51PM +0600, Murat Kabilov wrote:
>> I would like to know if there is a function that extracts an element by its
>> index from an array?
>
> No, the syntax most people expect and use would be arr[ndx]. If you
> want a function, it would be easy to do:
>
> CREATE FUNCTION array_index(anyarray,int)
> RETURNS anyelement IMMUTABLE
> LANGUAGE sql AS $$
> SELECT $1[$2]; $$;
but, why would you write a function to do this?
merlin