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. Also, it's

[SQL] Substrings by Regular Expression

2003-11-19 Thread Jim Drummey
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? TIA J. Drummey [EMAIL

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 parse , Am I