Re: RE in where - Mailing list pgsql-general

Patrick Nelson <pnelson@neatech.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