X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D98604763B1 for ; Tue, 13 May 2003 16:21:45 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 2CC6F4763A2 for ; Tue, 13 May 2003 16:21:45 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h4DKLdU6028981; Tue, 13 May 2003 16:21:40 -0400 (EDT) To: Larry Rosenman Cc: Stephan Szabo , josh@agliodbs.com, pgsql-sql@postgresql.org Subject: Re: Ok, how do I debug THIS? In-reply-to: <295850000.1052856801@lerlaptop.iadfw.net> References: <20030513130508.Q30384-100000@megazone23.bigpanda.com> <295850000.1052856801@lerlaptop.iadfw.net> Comments: In-reply-to Larry Rosenman message dated "Tue, 13 May 2003 15:13:21 -0500" Date: Tue, 13 May 2003 16:21:39 -0400 Message-ID: <28980.1052857299@sss.pgh.pa.us> From: Tom Lane X-Spam-Status: No, hits=-32.5 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/248 X-Sequence-Number: 13413 Larry Rosenman writes: >> Ugh. cidr doesn't appear to cast to text. You may be able to go through >> inet, but I'm not really sure because I haven't really used those types. > looks like I can, **BUT** is this the RIGHT thing? I suspect it SHOULD > cast to text. IMNSHO. Probably. We have an inet->text cast, and the same function would work for cidr->text. I think it's just an oversight that there's no such entry in pg_cast. You could add one by hand ... regards, tom lane