Hi,
I am trying to find the position of a character in a string which appears
multiple times.
The POSITION function returns the position of the character when it first
occurs.
For eg:
select position ( ' ' in 'Hi How are you');
This returns the result as "3".
But i need to result to be
3
7
On Mon, Dec 8, 2008 at 5:44 PM, Pawel Socha <[EMAIL PROTECTED]> wrote:
> 2008/12/8 ss_postgres <[EMAIL PROTECTED]>:
> > Hi,
> >
> > I am trying to find the position of a character in a string which appears
> > multiple times.
> >
> > The POSI