Thread: RE: [SQL] using matches on int4

What kind of matching are you trying to do?
Most likely you don't really need to create an operator.
    -DEJ

> -----Original Message-----
> 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
>

On Thu, 4 Feb 1999, Jackson, DeJuan wrote:

> What kind of matching are you trying to do?
> Most likely you don't really need to create an operator.

I was trying to find all people with ids of 200.

-Greg