Postgres Pro
Downloads
Home   >   mailing lists

A function to count all ocurrences of a character within a string. - Mailing list pgsql-sql

From Piotr Czekalski
Subject A function to count all ocurrences of a character within a string.
Date
Msg-id 4D754C0E.4030804@techbaza.pl
Whole thread Raw
Responses Re: A function to count all ocurrences of a character within a string.  (bricklen <bricklen@gmail.com>)
List pgsql-sql
Tree view 
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 by date:

Previous
From: S G
Date:
Subject: Re: distinguishing identical columns after joins
Next
From: bricklen
Date:
Subject: Re: A function to count all ocurrences of a character within a string.