using matches on int4

From: Gregory Holston <holston(at)itd(dot)nrl(dot)navy(dot)mil>
To: pgsql-sql(at)hub(dot)org
Subject: using matches on int4
Date: 1999-02-04 17:13:22
Message-ID: Pine.SUN.3.91.990204120927.10871E-100000@shell
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hi List,

I tried to do this query:
real=> select * from users where id ~ 2;
ERROR: There is no operator '~' for types 'int4' and 'int4'
You will either have to retype this query using an explicit cast,
or you will have to define the operator using CREATE OPERATOR
My question is how would I create an operator?

Thanks in advance,

-Greg

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jackson, DeJuan 1999-02-04 17:40:20 RE: [SQL] using matches on int4
Previous Message Tom Lane 1999-02-04 15:27:54 Re: Performance Question