Re: element from an array by its index - Mailing list pgsql-general

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]; $$;

--
  Sam  http://samason.me.uk/