X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6F1E7474E44 for ; Wed, 14 May 2003 13:04:02 -0400 (EDT) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with ESMTP id 00151-06 for ; Wed, 14 May 2003 13:03:59 -0400 (EDT) Received: from lerami.lerctr.org (lerami.lerctr.org [207.158.72.11]) by postgresql.org (Postfix) with ESMTP id 463564763F8 for ; Wed, 14 May 2003 13:03:59 -0400 (EDT) Received: from lerlaptop-red.iadfw.net (lerlaptop-red.iadfw.net [207.136.3.72]) (authenticated bits=0) by lerami.lerctr.org (8.12.9/8.12.9/20030225) with ESMTP id h4EH3tKK006074; Wed, 14 May 2003 12:03:56 -0500 (CDT) Date: Wed, 14 May 2003 12:03:55 -0500 From: Larry Rosenman To: Tom Lane , pgsql-sql@postgresql.org Subject: Re: Followup from yesterday's PL/pgSQL fun... Message-ID: <205620000.1052931835@lerlaptop-red.iadfw.net> In-Reply-To: <25296.1052931768@sss.pgh.pa.us> References: <177190000.1052930499@lerlaptop-red.iadfw.net> <25250.1052931519@sss.pgh.pa.us> <25296.1052931768@sss.pgh.pa.us> X-Mailer: Mulberry/3.0.3 (Linux/x86) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: by amavisd-milter (http://amavis.org/) X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/293 X-Sequence-Number: 13458 --On Wednesday, May 14, 2003 13:02:48 -0400 Tom Lane wrote: > I said: >> Larry Rosenman writes: >>> 3) how can I add text(cidr) myself? > >> Read the pg_cast description in >> http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=catalogs >> .html Insert a suitable row. > > Actually, I think you can do it with CREATE CAST. The issue (for me) was decoding the function name(s). I wish there was a \ command to display pg_cast... LER > > regards, tom lane -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749