PostgreSQL SELECT last array key from text[] array column

Question

How do I SELECT only the last key from an array column?

SELECT * FROM table;

+----+---------------+
| id | col_array     |
+----+---------------+
| 1  | {"a"}         |
+----+---------------+
| 2  | {"a","b","c"} |
+----+---------------+
| 3  | {"b","d","f"} |
+----+---------------+

The desired result for col_array would be: a, c, f.

Houari · Accepted Answer · 2015-03-16 19:38:44Z

1

Using array_upper

select col_array [array_upper(col_array, 1)] from my_table

answered Mar 16, 2015 at 19:38

Houari

5,6513 gold badges33 silver badges57 bronze badges

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

1 Comment

John Over a year ago

Ah, I should have realized arrays had their own functions in PostgreSQL, thanks!

Collectives™ on Stack Overflow

PostgreSQL SELECT last array key from text[] array column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related