> -----Original Message-----
> From: Charles Curley [SMTP:charles(dot)h(dot)curley(at)lmco(dot)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';