RE in where

Lists: pgsql-general
From: Patrick Nelson <pnelson(at)neatech(dot)com>
To: "PostgreSQL List (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: RE in where
Date: 2003-02-17 20:03:11
Message-ID: 4165C48DE9A0D211B6400800095C585F172F52@WASHINGTON
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Ran a query that I run periodically and it no longer works. It looks like:

SELECT * FROM hosts WHERE host ~ '^61.216.';

However, now I get an error:

ERROR: Unable to identify an operator '~' for types 'inet' and '"unknown"'
You will have to retype this query using an explicit cast

Anyone know what I've got going that is wrong?