Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 38CA8476E39 for ; Wed, 22 Jan 2003 01:13:06 -0500 (EST) Received: from mail02.up.edu.ph (unknown [210.14.43.1]) by postgresql.org (Postfix) with SMTP id 2BCE3476402 for ; Wed, 22 Jan 2003 01:11:38 -0500 (EST) Received: (qmail 28734 invoked by uid 504); 22 Jan 2003 06:43:36 -0000 Received: from ryanne.cruz@up.edu.ph by web2 with qmail-scanner-1.01 (update: v4243 15 Jan 2003. Clean. Processed in 0.565337 secs); 22 Jan 2003 06:43:36 -0000 Received: from unknown (HELO b01.mail.up.edu.ph) (10.16.3.1) by 10.16.3.144 with SMTP; 22 Jan 2003 06:43:36 -0000 Received: (qmail 21365 invoked by uid 504); 22 Jan 2003 06:15:11 -0000 Received: from ryanne.cruz@up.edu.ph by b01 with qmail-scanner-1.01 (update: v4243 15 Jan 2003. Clean. Processed in 0.460357 secs); 22 Jan 2003 06:15:11 -0000 Received: from unknown (HELO localhost) ([10.16.3.5]) (envelope-sender ) by 10.16.3.1 (qmail-ldap-1.03) with SMTP for ; 22 Jan 2003 06:15:10 -0000 Received: from 10.33.187.83 ( [10.33.187.83]) as user rocruz1@b04.mail.up.edu.ph by mail.up.edu.ph with HTTP; Wed, 22 Jan 2003 14:25:28 +0800 Message-ID: <1043216728.3e2e39585c6f3@mail.up.edu.ph> Date: Wed, 22 Jan 2003 14:25:28 +0800 From: ryanne cruz To: pgsql-php@postgresql.org Subject: rtrim MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.1 X-Originating-IP: 10.33.187.83 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/35 X-Sequence-Number: 1780 hi list. if there's anyone here who's familiar with teh rtrim function, please i need help. i have a table that has a column in it that has data in this format: California, USA Nevada, USA . . . when i use rtrim to erase the ", USA" part, it only sometimes work. a sample result would be: California Nevad my query statement is: update table set name=rtrim(name,', USA'); why is it that it only works sometimes?