Re: postgres function
| От | Ramesh T |
|---|---|
| Тема | Re: postgres function |
| Дата | |
| Msg-id | CAK8Zd=vEoeMO0N57sHY3XZOGcLdS3_Jjb9OmMtwotEW_8NNRsg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: postgres function ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Ответы |
Re: postgres function
Re: postgres function Re: postgres function |
| Список | pgsql-general |
'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---4But I want second occurrence,position-------------8plz any help..?SELECT length((regexp_matches('123-987-123', '(\d{3}-\d{3}-)\d{3}'))[1])David J.
В списке pgsql-general по дате отправления: