Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 04E46475BC3 for ; Wed, 22 Jan 2003 08:29:48 -0500 (EST) Received: from wolff.to (wolff.to [66.93.249.74]) by postgresql.org (Postfix) with SMTP id 51AF94759AF for ; Wed, 22 Jan 2003 08:29:47 -0500 (EST) Received: (qmail 4676 invoked by uid 500); 22 Jan 2003 13:42:21 -0000 Date: Wed, 22 Jan 2003 07:42:21 -0600 From: Bruno Wolff III To: ryanne cruz Cc: pgsql-php@postgresql.org Subject: Re: rtrim Message-ID: <20030122134221.GA4598@wolff.to> Mail-Followup-To: ryanne cruz , pgsql-php@postgresql.org References: <1043216728.3e2e39585c6f3@mail.up.edu.ph> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1043216728.3e2e39585c6f3@mail.up.edu.ph> User-Agent: Mutt/1.3.25i X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/43 X-Sequence-Number: 1788 On Wed, Jan 22, 2003 at 14:25:28 +0800, ryanne cruz wrote: > > 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 You may want to keep the country as a separate column.