Re: RE in where [SOLVED]

From: Patrick Nelson <pnelson(at)neatech(dot)com>
To: "PostgreSQL List (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: RE in where [SOLVED]
Date: 2003-02-17 22:51:36
Message-ID: 4165C48DE9A0D211B6400800095C585F172F55@WASHINGTON
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Browse pgsql-general by date

  From Date Subject
Next Message Tony Grant 2003-02-17 22:55:56 Re: accent = no accent
Previous Message Tom Lane 2003-02-17 22:49:54 Re: TIMESTAMP WITH( OUT)? TIME ZONE indexing/type choice...