regexp err msg question

["Gauthier, Dave" <dave.gauthier@xxxxxxxxx>]

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 !