Postgres Pro
Downloads
Home   >   mailing lists

Thread: Re: RE in where [SOLVED]

Re: RE in where [SOLVED]

From
Patrick Nelson
Date:
Tom Lane wrote:
----------------->>>>
The inet-to-text cast isn't implicit anymore.  You need an explicit
cast:
  SELECT * FROM hosts WHERE host::text ~ '^61.216.';
----------------->>>>

Worked like a charm...

Looked in the documentation but didn't see any ref to it.  Any others
besides inet and unknown?