"Gauthier, Dave" <dave.gauth...@intel.com> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
