Postgresql Not equal to string

Question

I have a column get_parameter in my table comments.

A get_parameter is a string that looks like this:

number1=7013448034

I need to extract the number from the above so that I'm left with just 7013448034.

How can I select that substring and get rid of number1= using PostgreSQL?

RaviH · Accepted Answer · 2014-02-10 16:30:37Z

2

SELECT SUBSTRING(get_parameter from '[0-9]*$') FROM comments

answered Feb 10, 2014 at 16:30

RaviH

3,5942 gold badges17 silver badges14 bronze badges

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

Comments

Jacob Waller · Accepted Answer · 2014-02-10 16:59:37Z

1

Here is another way of doing it. I think using the array functions might be useful.


SELECT num[2] FROM (SELECT regexp_split_to_array('number1=7013448034', E'=') as num) as query;

Check out

for more information.

answered Feb 10, 2014 at 16:59

Jacob Waller

4,2793 gold badges28 silver badges33 bronze badges