Re: CAST(ipaddress as text) -- HOW?

hi,

ipaddress::text

is resulting in

ERROR:   Cannot cast type 'cidr' to 'text'

how else we can???


Thankx.


On Tue, 17 Jul 2001, omid omoomi wrote:

> ie,
> ipaddrss::text
> 
> >From: Bhuvan A <bhuvansql@yahoo.com>
> >To: pgsql-sql@postgresql.org
> >Subject: [SQL] CAST(ipaddress as text)   -- HOW?
> >Date: Tue, 17 Jul 2001 19:35:53 +0530 (IST)
> >
> >
> >hi all,
> >
> >how can we cast an ipaddress(type cidr) to any other type?
> >
> >thankx in advance..
> >
> >
> >Regards,
> >
> >Bhuvaneswar.
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 3: if posting/reading through Usenet, please send an appropriate
> >subscribe-nomail command to majordomo@postgresql.org so that your
> >message can get through to the mailing list cleanly
> 
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>