X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 055AFD1B591 for ; Wed, 19 Nov 2003 20:43:02 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 62074-08 for ; Wed, 19 Nov 2003 16:42:32 -0400 (AST) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 52371D1B547 for ; Wed, 19 Nov 2003 16:42:30 -0400 (AST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id CBB92352EC; Wed, 19 Nov 2003 12:42:31 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id CA3A4352E6; Wed, 19 Nov 2003 12:42:31 -0800 (PST) Date: Wed, 19 Nov 2003 12:42:31 -0800 (PST) From: Stephan Szabo To: Jim Drummey Cc: pgsql-sql@postgresql.org Subject: Re: Substrings by Regular Expression In-Reply-To: <463bd40b.0311140902.27de95a5@posting.google.com> Message-ID: <20031119124031.G91425@megazone.bigpanda.com> References: <463bd40b.0311140902.27de95a5@posting.google.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/245 X-Sequence-Number: 16060 On Fri, 14 Nov 2003, Jim Drummey wrote: > Hello- > > The 7.2 version distributed with RedHat 8.0 seems not > to work for substrings and POSIX regular expressions. > > I think this should work.... > > pds=> select substring( str1 from ',' ) from address; > ERROR: pg_atoi: error in ",": can't parse "," > > Am I missing something? That functionality was added in 7.3 I believe. You may wish to upgrade.