looking for an 'array_index' function? - Mailing list pgsql-hackers

From Fabien COELHO
Subject looking for an 'array_index' function?
Date
Msg-id Pine.LNX.4.58.0403191610350.15910@sablons.cri.ensmp.fr
Whole thread Raw
Responses Re: looking for an 'array_index' function?
List pgsql-hackers
Dear hackers,

I'm looking for an array_index function that would return the index of the
occurence of some element in an array. I noticed that I can know whether a
element is in the array with ANY, but I also need the actual index.

There is no such function under that name, and I cannot find any that
would do the job in the doc. I made a quick workaround in plpgsql, but I
would have expected the function to be there.

Am I unlucky or just blind?

I know that looking for such a function is a proof a bad design, but I
don't feel responsible for the pg_catalog.* design;-)

Thanks in advance for any pointer,

Have a nice day,

-- 
Fabien Coelho - coelho@cri.ensmp.fr


pgsql-hackers by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Question on restoring and compiled plans
Next
From: Andrew Dunstan
Date:
Subject: Re: COPY formatting