"Gauthier, Dave" <dave.gauthier@xxxxxxxxx> writes: > 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) You realize of course that you've got too many quotes there. > Could someone explain the error message? I think it's parsing that as name ~ '' ^ foo '' That is, empty string literal, ^ operator, typename preceding string literal, empty string literal. The "typename 'string'" syntax wasn't one of the SQL committee's better ideas :-( regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
