regexp err msg question - Mailing list pgsql-general

Hi:

8.3.4 on linux

This query fails with this message...

mydb=# select distinct fivr from alphaview where name ~ ''^foo'';

ERROR: type "foo" does not exist

(note: those are two single quotes before the ^ and after foo, NOT double quotes)

Could someone explain the error message?

Thanks in Advance !