Postgres Pro
Downloads
Home   >   mailing lists

SELECT substring with regex - Mailing list pgsql-sql

From T E Schmitz
Subject SELECT substring with regex
Date
Msg-id 44AE66E0.1040606@numerixtechnology.de
Whole thread Raw
Responses Re: SELECT substring with regex
List pgsql-sql
Tree view 
I would like to split the contents of a column using substring with a 
regular expression:

SELECT substring (NAME, '^\\d+mm') as BASE_NAME, substring (NAME, ??? ) as SUFFIX
FROM MODEL

The column contains something like
"150mm LD AD Asp XR Macro"
I want to split this into
"150mm", "LD AD Asp XR Macro"

How can I extract the bit following the matching substring?

-- 


Regards,

Tarlika Elisabeth Schmitz

pgsql-sql by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: How to get list of days between two dates?
Next
From: "James Moliere"
Date:
Subject: create aggregate function 'count_bool( column_name, boolean )'