Postgres Pro
Downloads
Home   >   mailing lists

Substrings by Regular Expression - Mailing list pgsql-sql

From drumeng@yahoo.com (Jim Drummey)
Subject Substrings by Regular Expression
Date
Msg-id 463bd40b.0311140902.27de95a5@posting.google.com
Whole thread Raw
Responses Re: Substrings by Regular Expression
List pgsql-sql
Tree view 
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
drumeng@yahoo.com

pgsql-sql by date:

Previous
From: Gulshan Babajee
Date:
Subject: Compare strings which resembles each other
Next
From: Yasir Malik
Date:
Subject: Re: Getting last insert value