Extract a portion of an array in postgresql

Question

I have an array of type character.

For ex: {AA,BB,CC,DD,EE,FF,GG, hh, II, jj,KK}

From the above array i need to extract for ex: from 3rd position to 7th position which is {CC,DD,EE,FF,GG}

Please let me know how to achieve this.

Answer 1

If you know the positions, you can simple do this:

SELECT myarray[3:7] FROM mytable ...;