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 !