Re: Substrings by Regular Expression

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Jim Drummey <drumeng(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Substrings by Regular Expression
Date: 2003-11-19 20:42:31
Message-ID: 20031119124031.G91425@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Iain 2003-11-20 02:37:33 fmgr_info: function 15238119: cache lookup failed
Previous Message Michael Glaesemann 2003-11-19 10:34:45 Re: Need Help : Query problem