Many thanks... got it now.
Example...
sox=# select * from regexpatt;
pattern |description
-+
^b | starts with a B
^a | starts with an A
^c.*l$ | starts with a C and ends with an L
(3 rows)
sox=# select description from regex
Moonstruck,
> I want to create a table of regular expression patterns (for assessing
> phone numbers), something like:
> CREATE TABLE CallType ( pattern varchar primary key,
> typevarchar,
> rateint4);
> INSERT INTO CallType VALUES ('0[3-9]_
On Mon, 2003-08-18 at 03:05, Moonstruck wrote:
> I want to create a table of regular expression patterns (for assessing
> phone numbers), something like:
> CREATE TABLE CallType ( pattern varchar primary key,
> typevarchar,
> rateint4);
> INS
I want to create a table of regular expression patterns (for assessing
phone numbers), something like:
CREATE TABLE CallType ( pattern varchar primary key,
typevarchar,
rateint4);
INSERT INTO CallType VALUES ('0[3-9]','Interstate Call
