using matches on int4 - Mailing list pgsql-sql

From Gregory Holston
Subject using matches on int4
Date
Msg-id Pine.SUN.3.91.990204120927.10871E-100000@shell
Whole thread Raw
List 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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance Question
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: [SQL] using matches on int4