| From: | John Zwiebel <jzwiebel(at)cisco(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | psql regular expression matching POSIX |
| Date: | 2005-02-07 22:34:29 |
| Message-ID: | 1107815972.576122@sj-nntpcache-3 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Could someone please provide me with the syntax for a REGEXP that will
match a column in a table?
ie, this works using "similar to":
select prod_id, prod_desc, vend_id from products where\
vend_id similar to '\[D|F]%'
In the docs:
pgsql/doc/html/functions-matching.html para 9.7.3
I'm suppose to be able to use POSIX regular expressions.
Say I want to match all the vendor IDs with "LL" located anywere
inside the vend_id.
select vend_id from products where <Now What???>
All of the examples in this section discuss "select substring"
All the variations I've tried of the following either are
syntax errors or 'type "vend_id" does not exist'.
SELECT vend_id from products where substring (vend_id '.*LL.*');
Thanks
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Zwiebel | 2005-02-07 22:41:40 | Re: psql regular expression matching POSIX |
| Previous Message | Colin McGuigan | 2005-02-07 18:45:12 | Re: Percent of update completed |