Postgres Pro
Downloads
Home   >   mailing lists

Re: Substrings by Regular Expression - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: Substrings by Regular Expression
Date
Msg-id 20031119124031.G91425@megazone.bigpanda.com
Whole thread Raw
In response to Substrings by Regular Expression  (drumeng@yahoo.com (Jim Drummey))
Responses Re: Substrings by Regular Expression  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: Yasir Malik
Date:
Subject: Re: Getting last insert value
Next
From: "Iain"
Date:
Subject: fmgr_info: function 15238119: cache lookup failed