Received: from bjke.com (firewall-user@ganymede.bjke.com [144.210.8.38]) by hub.org (8.9.2/8.9.1) with ESMTP id MAA10270 for ; Thu, 4 Feb 1999 12:38:36 -0500 (EST) (envelope-from djackson@cpsgroup.com) Received: by bjke.com; id LAA05026; Thu, 4 Feb 1999 11:38:31 -0600 (CST) Received: from cpsmail.cpsgroup.com(144.210.12.11) by gauntlet.bjke.com via smap (4.1) id xmaa04519; Thu, 4 Feb 99 11:38:08 -0600 Received: by cpsmail with Internet Mail Service (5.0.1458.49) id ; Thu, 4 Feb 1999 11:40:21 -0600 Message-ID: From: "Jackson, DeJuan" To: Gregory Holston , pgsql-sql@hub.org Subject: RE: [SQL] using matches on int4 Date: Thu, 4 Feb 1999 11:40:20 -0600 X-Priority: 3 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.0.1458.49) Content-Type: text/plain 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 >