Cut a number from row and insert into new column
I have a table where one column contains a long description with a street number and I want to pick that value , like we have three rows below:
postgresql getting data between characters : and ] differing lengths of data between characters
New to data mining like this. My first post. Apologies if I did something wrong.