A function to count all ocurrences of a character within a string.

Поиск
Список
Период
Сортировка
От Piotr Czekalski
Тема A function to count all ocurrences of a character within a string.
Дата
Msg-id 4D754C0E.4030804@techbaza.pl
обсуждение исходный текст
Ответы Re: A function to count all ocurrences of a character within a string.  (bricklen <bricklen@gmail.com>)
Список pgsql-sql
Hello pgsql community,

Is there any string function (other than regex / scan & compare loop) to 
obtain a list (or even a count) of characters within a string?
strpos and position seems to return only first occurence of a 
char/string within substring.
The goal is to check if a string contains equal number of opening and 
closing parenthesis, and if there are any of them.

Regards,

Piotr Czekalski

-- 

--------------------------------------------------------------
"TECHBAZA.PL" Sp. z o.o.
Technologie WEB, eDB&  eCommerce
tel. (+4832) 7186081
fax. (+4832) 7003289
email: biuro@techbaza.pl




В списке pgsql-sql по дате отправления:

Предыдущее
От: S G
Дата:
Сообщение: Re: distinguishing identical columns after joins
Следующее
От: bricklen
Дата:
Сообщение: Re: A function to count all ocurrences of a character within a string.