How to access element in postgresql string array

Question

regex_matches returns a string array : {first match, second match}. How do I access the elements within it? I have tried:

regex_matches('mystring', 'my string pattern')[0]
regex_matches('mystring', 'my string pattern') as url[0]
regex_matches('mystring', 'my string pattern') as url, url[0]

Nothing works. Do I really need to do a string function to replace the two braces? That seems pretty clunky

Pavel Stehule · Accepted Answer · 2014-09-05 21:28:30Z

6

you have to use extra parenthesis:

postgres=# select regexp_matches('123 333'::text, '\d{3}'::text, 'g');
 regexp_matches 
----------------
 {123}
 {333}
(2 rows)

postgres=# select (regexp_matches('123 333'::text, '\d{3}'::text, 'g'))[1];
 regexp_matches 
----------------
 123
 333
(2 rows)

answered Sep 5, 2014 at 21:28

Pavel Stehule

46.7k6 gold badges104 silver badges103 bronze badges

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

Collectives™ on Stack Overflow

How to access element in postgresql string array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related