RE: [GENERAL] Another Regular Expression "Problem"

> -----Original Message-----
> From:    Charles Curley [SMTP:charles.h.curley@lmco.com]
> Sent:    Thursday, October 15, 1998 2:52 PM
> To:    PostgreSQL Mailing List
> Subject:    [GENERAL] Another Regular Expression "Problem"
>
> 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?
> try:
    SELECT "first", "last"
     FROM "employees"
    WHERE "first" ~ '^Charles|^James';