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 MAA15121 for ; Tue, 23 Feb 1999 12:11:33 -0500 (EST) (envelope-from djackson@cpsgroup.com) Received: by bjke.com; id LAA21345; Tue, 23 Feb 1999 11:11:29 -0600 (CST) Received: from cpsmail.cpsgroup.com(144.210.12.11) by gauntlet.bjke.com via smap (4.1) id xmaa20271; Tue, 23 Feb 99 11:10:30 -0600 Received: by cpsmail with Internet Mail Service (5.0.1458.49) id ; Tue, 23 Feb 1999 11:13:17 -0600 Message-ID: From: "Jackson, DeJuan" To: The Hermit Hacker , pgsql-sql@postgreSQL.org Subject: RE: [SQL] inet type SELECT ... Date: Tue, 23 Feb 1999 11:13:16 -0600 X-Priority: 3 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.0.1458.49) Content-Type: text/plain select etheraddr from ethernets2 where ip << '131.162.2/24'; > -----Original Message----- > How would I write this query so that it works? > > select etheraddr from ethernets2 where ip like '131.162.2.%'; > > where ip is of type 'inet'... > > I get an error to the effect of: > > hostmgmt=> \e > ERROR: There is more than one possible operator '~~' for > types 'inet' and > 'unknown'. You will have to retype this query using > an explicit > cast > > > Marc G. Fournier > Systems Administrator @ hub.org > primary: scrappy@hub.org secondary: > scrappy@{freebsd|postgresql}.org