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.

MatheusOl · Accepted Answer · 2013-09-12 12:50:59Z

2

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

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

answered Sep 12, 2013 at 12:50

MatheusOl

12k3 gold badges33 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

+1, I'd also add that PostgreSQL have 1-based indexing, which is not very common

+1, you can use the unnest(myarray) function to have the array values in separate rows. Note that: It will duplicate the records you have.