regexp err msg question

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: pgsql-general List <pgsql-general(at)postgresql(dot)org>
Subject: regexp err msg question
Date: 2010-12-07 15:20:13
Message-ID: 482E80323A35A54498B8B70FF2B87980047DDA01D6@azsmsx504.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 !

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitriy Igrishin 2010-12-07 15:23:16 Re: Do we want SYNONYMS?
Previous Message Andy Colson 2010-12-07 15:19:17 Re: Do we want SYNONYMS?