RE in where

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
Thread:
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?

Browse pgsql-general by date

  From Date Subject
Next Message Bodanapu, Sravan 2003-02-17 20:42:04 Re: Table Partitioning in Postgres:
Previous Message Randy Zierman 2003-02-17 19:55:37 Compatible UNION query for postgresql and MS SQL Server