Re: [SQL] Substrings by Regular Expression

2003-11-21 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > On Fri, 14 Nov 2003, Jim Drummey wrote: >> 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

Re: [SQL] Substrings by Regular Expression

2003-11-19 Thread Stephan Szabo
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 pars