Postgres Pro
Downloads
Home   >   mailing lists

Re: RE in where - Mailing list pgsql-general

From Patrick Nelson
Subject Re: RE in where
Date
Msg-id 4165C48DE9A0D211B6400800095C585F172F53@WASHINGTON
Whole thread Raw
In response to RE in where  (Patrick Nelson <pnelson@neatech.com>)
Responses Re: RE in where
List pgsql-general
Tree view 
Patrick Nelson wrote:
----------------->>>>
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?
----------------->>>>
More info:

Oh this is v7.3.1-1PGDG running on RH73 (server) and RH72 (clients)

This seems to be only with the inet data type.  The other data types I try
with the ~ (or ~~) work fine.

pgsql-general by date:

Previous
From: Jonathan Bartlett
Date:
Subject: Re: Table Partitioning in Postgres:
Next
From: Andrew Sullivan
Date:
Subject: Re: How do people do schema upgrades?