Re: [ADMIN] How to find the position of a characted in a string

2008-12-09 Thread Pawel Socha
2008/12/8 ss_postgres <[EMAIL PROTECTED]>: > > > 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. >> > >> > T

Re: [ADMIN] How to find the position of a characted in a string

2008-12-08 Thread ss_postgres
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 POSITION function returns the position of the character whe

Re: [ADMIN] How to find the position of a characted in a string

2008-12-07 Thread Pawel Socha
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 POSITION function returns the position of the character when it first > occurs. > > For eg: > > select position ( ' ' in 'Hi How are you'); > > Th

[ADMIN] How to find the position of a characted in a string

2008-12-07 Thread ss_postgres
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