Re: RE in where

Patrick Nelson <pnelson(at)neatech(dot)com> writes:
> 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

The inet-to-text cast isn't implicit anymore. You need an explicit
cast:
SELECT * FROM hosts WHERE host::text ~ '^61.216.';

regards, tom lane