pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bhuvan A <bhuvansql@yahoo.com>
To: omid omoomi <oomoomi@hotmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: CAST(ipaddress as text) -- HOW?
Date: Sat, 21 Jul 2001 11:28:52 +0530 (IST)
Message-ID: <Pine.LNX.4.20.0107211126100.4270-100000@Larry.bks> (raw)
In-Reply-To: <F2418VUkRacUtI9dm5U000006da@hotmail.com>


hi

ipaddr::text 

I got it!

few among the many ways are

SELECT * FROM .. WHERE CAST(ipaddr::inet as text) ~ '200';
SELECT * FROM .. WHERE text(ipaddr::inet) ~ '200';
SELECT * FROM .. WHERE host(ipaddr::inet) ~ '200';

Regards,
Bhuvaneswar.


On Thu, 19 Jul 2001, omid omoomi wrote:

> Sorry  friend, you are right. I could not do that too. :o
> I'll look for it.
> omid
> 
> >From: Bhuvan A <bhuvansql@yahoo.com>
> >To: omid omoomi <oomoomi@hotmail.com>
> >CC: pgsql-sql@postgresql.org
> >Subject: Re: [SQL] CAST(ipaddress as text) -- HOW?
> >Date: Wed, 18 Jul 2001 14:53:04 +0530 (IST)
> >
> >
> >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.
> > >
> >
> 
> 
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
> 




view thread (3+ messages)

Message-ID: <Pine.LNX.4.20.0107211126100.4270-100000@Larry.bks>
Permalink:  ../Pine.LNX.4.20.0107211126100.4270-100000@Larry.bks/
Also on:    postgresql.org/message-id/Pine.LNX.4.20.0107211126100.4270-100000@Larry.bks

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: bhuvansql@yahoo.com, oomoomi@hotmail.com
  Subject: Re: CAST(ipaddress as text) -- HOW?
  In-Reply-To: <Pine.LNX.4.20.0107211126100.4270-100000@Larry.bks>
  References: <F2418VUkRacUtI9dm5U000006da@hotmail.com> <Pine.LNX.4.20.0107211126100.4270-100000@Larry.bks>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox