Home > mailing lists

Re: How to covert 'char' to 'inet' - Mailing list pgsql-general

From	Andrew Sullivan
Subject	Re: How to covert 'char' to 'inet'
Date	July 23, 2002 13:37:35
Msg-id	20020723103739.C23294@mail.libertyrms.com Whole thread Raw
In response to	How to covert 'char' to 'inet' (mnihas@poczta.onet.pl (Michal O))
Responses	time setting
List	pgsql-general

Tree view

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@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110

pgsql-general by date:

From: Jan Wieck
Date: 23 July 2002, 13:35:56
Subject: Re: Stats Collector

From: "Craig Sturman"
Date: 23 July 2002, 13:44:57
Subject: time setting

Re: How to covert 'char' to 'inet' - Mailing list pgsql-general

Previous

Next