Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres function - Mailing list pgsql-general

From Ramesh T
Subject Re: postgres function
Date
Msg-id CAK8Zd=vEoeMO0N57sHY3XZOGcLdS3_Jjb9OmMtwotEW_8NNRsg@mail.gmail.com
Whole thread Raw
In response to Re: postgres function  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: postgres function  (Joe Conway <mail@joeconway.com>)
Re: postgres function  (Geoff Winkless <pgsqladmin@geoff.dj>)
Re: postgres function  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
'123-987-123' it is not fixed some times it may be '1233-9873-123-098'
as you said it's fixed,

changes the values in middle of the -

sometimes times i need 1233 and 098 or 9873,first position  i'll find direct for second variable we don't know where it's end with -

i.e ,
i need to find second postition of the variable between the '-'


                     
On Thu, Oct 15, 2015 at 6:32 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Thu, Oct 15, 2015 at 8:32 AM, Ramesh T <rameshparnanditech@gmail.com> wrote:
 select position('-' in '123-987-123')
position
---
4
But I want second occurrence,
position
-------------
8

plz any help..?

 
​
SELECT length((regexp_matches('123-987-123', '(\d{3}-\d{3}-)\d{3}'))[1])
​

David J.


pgsql-general by date:

Previous
From: Ramesh T
Date:
Subject: Re: postgres function
Next
From: Adrian Klaver
Date:
Subject: Re: Installing plpython3u