Substrings by Regular Expression

From: drumeng(at)yahoo(dot)com (Jim Drummey)
To: pgsql-sql(at)postgresql(dot)org
Subject: Substrings by Regular Expression
Date: 2003-11-14 17:02:48
Message-ID: 463bd40b.0311140902.27de95a5@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)yahoo(dot)com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message ow 2003-11-15 04:36:16 Programatically switching database
Previous Message Gulshan Babajee 2003-11-14 05:30:27 Compare strings which resembles each other