pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Richard DeVenezia <radevenz@ix.netcom.com>
To: sqllist <pgsql-sql@postgresql.org>
Subject: Is there a string to inet function that can be used in order by ?
Date: Fri, 24 Nov 2000 09:24:19 -0500
Message-ID: <001b01c05622$3cf24100$0101a8c0@supermicro> (raw)

I have a table of strings categorized by string type and unique id

e.g.

stringTypes table (sType, sDescription)
0 vanilla
1 ip address
2 mail address

stringValues table (sId, sType, sValue)
1 0 foobar
2 2 123 Main Street
3 1 123.123.123.123
3 1 123.13.123.123

I want to select ip address type strings and order them by ip address.  However I can not find a function that returns an inet given a string.

e.g.

select sValue from stringValues A, stringTypes B
where A.sType = B.sType and B.sType = 1
order by [**** function that converts string to INET ****] (A.sValue);

TIA

Richard DeVenezia

Message-ID: <001b01c05622$3cf24100$0101a8c0@supermicro>
Permalink:  ../001b01c05622$3cf24100$0101a8c0@supermicro/
Also on:    postgresql.org/message-id/001b01c05622$3cf24100$0101a8c0@supermicro

 · 

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: radevenz@ix.netcom.com
  Subject: Re: Is there a string to inet function that can be used in order by ?
  In-Reply-To: <001b01c05622$3cf24100$0101a8c0@supermicro>
  References: <001b01c05622$3cf24100$0101a8c0@supermicro>

* 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