[ADMIN] upgrade via rpm

Hello, we're planning an upgrade from Postgres 8.3.1 to latest 8.3.5 via rpm (Opensuse 10.3 - 64bit). Is it really that simple ? 1.) stop cluster (e.g. pg_ctl stop) 2.) perform the upgrade (rpm -Uvh *.rpm) 3.) start the cluster (pg_ctl start) thanks in advanceGERD. -- Sent via

Re: [ADMIN] upgrade via rpm

On Sun, Dec 7, 2008 at 1:23 PM, Gerd Koenig [EMAIL PROTECTED] wrote: Hello, we're planning an upgrade from Postgres 8.3.1 to latest 8.3.5 via rpm (Opensuse 10.3 - 64bit). Is it really that simple ? 1.) stop cluster (e.g. pg_ctl stop) 2.) perform the upgrade (rpm -Uvh *.rpm) 3.) start the

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

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

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

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'); This returns the