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 NAA13227 for ; Thu, 4 Feb 1999 13:01:00 -0500 (EST) (envelope-from djackson@cpsgroup.com) Received: by bjke.com; id MAA00547; Thu, 4 Feb 1999 12:00:59 -0600 (CST) Received: from cpsmail.cpsgroup.com(144.210.12.11) by gauntlet.bjke.com via smap (4.1) id xmaa29977; Thu, 4 Feb 99 12:00:27 -0600 Received: by cpsmail with Internet Mail Service (5.0.1458.49) id ; Thu, 4 Feb 1999 12:02:41 -0600 Message-ID: From: "Jackson, DeJuan" To: Gregory Holston , "Jackson, DeJuan" Cc: pgsql-sql@hub.org Subject: RE: [SQL] using matches on int4 Date: Thu, 4 Feb 1999 12:02:39 -0600 X-Priority: 3 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.0.1458.49) Content-Type: text/plain if you want to match all id's that start with 2 try [you might also what to create a functional index on id as text(id)]: select * from users where id::text ~~ (2::text || '%'); or select * from users where id::text ~ ('^' || 2::text); if you are trying to get exactly 200 use: select * from users where id=200; -DEJ > -----Original Message----- > 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 >