Re: RE in where [SOLVED] - Mailing list pgsql-general

From Patrick Nelson
Subject Re: RE in where [SOLVED]
Date
Msg-id 4165C48DE9A0D211B6400800095C585F172F55@WASHINGTON
Whole thread Raw
List pgsql-general
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?

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: TIMESTAMP WITH( OUT)? TIME ZONE indexing/type choice...
Next
From: Justin Clift
Date:
Subject: Re: shmget problem with Win NT services