Re: [GENERAL] Regex problems

> select "dept", "last", "first" from "employees" where "last" ~ 'C*';

You want:

> select "dept", "last", "first" from "employees" where "last" ~ '^C';

or

> select "dept", "last", "first" from "employees" where "last" ~ '^C.*';

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026