[GENERAL] Another Regular Expression "Problem"

From: Charles Curley <charles(dot)h(dot)curley(at)lmco(dot)com>
To: PostgreSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: [GENERAL] Another Regular Expression "Problem"
Date: 1998-10-15 19:52:11
Message-ID: 3626526B.7877A14B@lmco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hopefully I'm not being dense again ...

I've got a CGI frontend that I'd like to give users the ability to type
in regular expressions into forms and do queries based up this data.
During testing things work fine as long as I keep with simple
expressions like:

select "first", "last" from "employees" where "first" ~ '^Charles'

But if I do something like the following, I get nothing:

select "first", "last" from "employees" where "first" ~
'^(Charles)|(James)'

I looked down in src/backend/regex at re_format.7 and this is explained
in that document as "extended" RE's. I've tried this RE with egrep and
it matches lines like I want (pretty simple stuff here). What gives?
--
Charles Curley, Staff Engineer
Computer Integrated Manufacturing
Lockheed Martin Ocala Operations

Browse pgsql-general by date

  From Date Subject
Next Message Jackson, DeJuan 1998-10-15 20:29:58 RE: [GENERAL] Another Regular Expression "Problem"
Previous Message Andy Lewis 1998-10-15 19:22:52 Easiest and shortest way?