Received: from granger.mail.mindspring.net (granger.mail.mindspring.net [207.69.200.148]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAOENxA41591 for ; Fri, 24 Nov 2000 09:23:59 -0500 (EST) (envelope-from radevenz@ix.netcom.com) Received: from supermicro (pool-63.53.155.207.nwrk.grid.net [63.53.155.207]) by granger.mail.mindspring.net (8.9.3/8.8.5) with SMTP id JAA29818 for ; Fri, 24 Nov 2000 09:24:00 -0500 (EST) Message-ID: <001b01c05622$3cf24100$0101a8c0@supermicro> From: "Richard DeVenezia" To: "sqllist" Subject: Is there a string to inet function that can be used in order by ? Date: Fri, 24 Nov 2000 09:24:19 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0018_01C055F8.52E47C50" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 X-Archive-Number: 200011/219 X-Sequence-Number: 250 This is a multi-part message in MIME format. ------=_NextPart_000_0018_01C055F8.52E47C50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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. How= ever 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 =3D B.sType and B.sType =3D 1 order by [**** function that converts string to INET ****] (A.sValue); TIA Richard DeVenezia ------=_NextPart_000_0018_01C055F8.52E47C50 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I have a table of strings categorized by string type an= d=20 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=20 address.  However I can not find a function that returns an inet given= a=20 string.
 
e.g.
 
select sValue from stringValues A, stringTypes B=
where A.sType =3D B.sType and B.sType =3D 1
order by [**** function that converts string to INET **= **]=20 (A.sValue);
 
TIA
 
Richard DeVenezia
------=_NextPart_000_0018_01C055F8.52E47C50--