ction.
I was curious where the reference to "type" came from in the error message.
Thanks Tom.
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Tuesday, December 07, 2010 10:45 AM
To: Gauthier, Dave
Cc: pgsql-general List
Subject: Re: [GENERAL] regexp e
"Gauthier, Dave" 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 exp
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 Adva
