Postgres Pro
Downloads
Home   >   mailing lists

RE in where - Mailing list pgsql-general

From Patrick Nelson
Subject RE in where
Date
Msg-id 4165C48DE9A0D211B6400800095C585F172F52@WASHINGTON
Whole thread Raw
List pgsql-general
Tree view 
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?

pgsql-general by date:

Previous
From: "Randy Zierman"
Date:
Subject: Compatible UNION query for postgresql and MS SQL Server
Next
From: "Bodanapu, Sravan"
Date:
Subject: Re: Table Partitioning in Postgres: