X-Original-To: pgsql-interfaces@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 862A8476385 for ; Fri, 21 Mar 2003 21:27:39 -0500 (EST) Received: from mail.keta.mine.nu (CPE-144-137-103-104.nsw.bigpond.net.au [144.137.103.104]) by postgresql.org (Postfix) with SMTP id 06A8147637C for ; Fri, 21 Mar 2003 21:27:38 -0500 (EST) Received: (qmail 8719 invoked from network); 22 Mar 2003 02:27:41 -0000 Received: from unknown (HELO mianos) (mianos@192.168.1.251) by mail.keta.mine.nu with SMTP; 22 Mar 2003 02:27:41 -0000 Message-ID: <008001c2f01a$9cdcfee0$fb01a8c0@mianos> From: "Rob Fowler" To: "Michael Meskes" Cc: References: <20030321064112.GA5117@firewall.keta.mine.nu> <20030321150648.GB27690@feivel.fam-meskes.de> Subject: Re: embedded sql interface to ip address type Date: Sat, 22 Mar 2003 13:27:41 +1100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Spam-Status: No, hits=-9.8 required=5.0 tests=QUOTED_EMAIL_TEXT,REFERENCES version=2.50-cvs X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50-cvs (1.172-2003-02-14-exp) X-Archive-Number: 200303/130 X-Sequence-Number: 3879 > What exactly do you mean? A C type for IP addresses? That doesn't > exist. Right now this type has to be stored in character strings. Thanks for the answer Michael. That was exactly what I meant and your answer was exactly what I needed. I thought I needed to bind the address structure to the ipaddr column but that did not work so I changed the type to text and converted the address to a char string. Now you tell me it's just text, I went back and changed the database datatype to inet address and it's all good. -- Rob Fowler