PostgreSQL regex with OR condition in SUBSTRING function

Question

I want to recognize TIMESTAMP in PostgreSQL by using regexp:

SELECT substring('13:14:00', '([0-1][0-9]|2[0-3]):[0-5]\d:[0-5]\d')

This query returns 13, but I need to receive result 13:14:00.

Analogical query SELECT substring('134', '1(2|3)4') returns 3 instead of 134.

So, what is the problem? My psql version is 9.3.1.

Petr · Accepted Answer · 2014-12-15 09:38:43Z

2

Add parenthesis:

  SELECT substring('13:14:00', '(([0-1][0-9]|2[0-3]):[0-5]\d:[0-5]\d)');

answered Dec 15, 2014 at 9:38

Petr

1,20912 silver badges21 bronze badges

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

1 Answer 1