I get my information. If I do:
select "dept", "last", "first" from "employees" where "last" ~ 'C*';
I get the entire table's worth of matches (883) regardless of what the last name is. Examples that are matched:
The answer is you need to use the meta character that tells the regx engine to look at only the begining of the string for a match. That is your regular expression should be:
"^C"
or
"^C*"
which yields a query like:
select "dept", "last", "first" from "employees" where "last" ~ "^C";
Adding the 'u' is not a bad idea if you want to get only the last names that start with "Cu".
...james
