Received: from itd.nrl.navy.mil (s2.itd.nrl.navy.mil [132.250.83.3]) by hub.org (8.9.2/8.9.1) with ESMTP id MAA07028 for ; Thu, 4 Feb 1999 12:13:30 -0500 (EST) (envelope-from holston@itd.nrl.navy.mil) Received: from shell (shell [132.250.83.3]) by itd.nrl.navy.mil (8.8.8/8.8.8) with SMTP id MAA11485 for ; Thu, 4 Feb 1999 12:13:22 -0500 (EST) Date: Thu, 4 Feb 1999 12:13:22 -0500 (EST) From: Gregory Holston X-Sender: holston@shell To: pgsql-sql@hub.org Subject: using matches on int4 Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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