parsing fields

From: "Douglas Blood" <dblood(at)matraex(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: parsing fields
Date: 2002-09-11 14:35:12
Message-ID: 021a01c259a0$70141940$2000a8c0@spruce
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there a way in postgres to count how many instances of a character there
are in a varchar field?
I know how I can see if there is any instance of the character using
strpos() but that will only find if there is one and i would like the total
count of them.
Any help would be appriciated.
Douglas Blood
Matraex Inc.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Roland Roberts 2002-09-11 14:46:11 plpgsql trigger parse error
Previous Message Bruce Momjian 2002-09-11 14:31:00 Re: Mailing lists archive search