Re: How to covert 'char' to 'inet'

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to covert 'char' to 'inet'
Date: 2002-07-23 14:37:39
Message-ID: 20020723103739.C23294@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jul 23, 2002 at 04:29:21AM -0700, Michal O wrote:
> Hi !
> I've tried cast to convert char to inet, but that is no good waw :((.
> Does anybody know how to do that ?

Try trim(charfield)::inet. Worked for me. I think the problem is
that char is padded.

A

--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Sturman 2002-07-23 14:40:25 time setting
Previous Message Jan Wieck 2002-07-23 14:35:53 Re: Stats Collector