Re: how to count string occurrence in column

yes, this is what i want.

but this dont work :(
pg - 7.1.3

> > Actually i'm sure the original poster is after something like:
> >
> > SELECT count('qwerty qwert qwertyffff fff qq', 'qwerty');
> > count
> > --------
> > 2
> > (1 row)
> >
> > But off the top of my head i cannot think of a suitable standard
> > function...
>
> Woops, posted too quick. Maybe my posting doesn't answer the original
> question:
>
> column1
> row 1 'test test'
> row 2 'test'
>
> My statement would count 2. Maybe the OP would want 3. In that case, I
> think you'll have to write some code that counts substring occurences.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>