X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1FFFB475EDF for ; Wed, 14 May 2003 12:41:41 -0400 (EDT) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with ESMTP id 90213-09 for ; Wed, 14 May 2003 12:41:39 -0400 (EDT) Received: from lerami.lerctr.org (lerami.lerctr.org [207.158.72.11]) by postgresql.org (Postfix) with ESMTP id 80428475E25 for ; Wed, 14 May 2003 12:41:39 -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 h4EGfgKK003021 for ; Wed, 14 May 2003 11:41:43 -0500 (CDT) Date: Wed, 14 May 2003 11:41:39 -0500 From: Larry Rosenman To: pgsql-sql@postgresql.org Subject: Followup from yesterday's PL/pgSQL fun... Message-ID: <177190000.1052930499@lerlaptop-red.iadfw.net> 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/286 X-Sequence-Number: 13451 I posted: Also, this is what I wound up with for that line, which seems ugly, because it couldn't find a quote_literal(inet) without the ::text on it: quote_literal(NEW.netblock::inet::text) ; Is that right? Can I ask 3 questions: 1) should quote_literal find a ::text conversion on it's own? 2) can text(cidr) be added to the default pg_cast table? 3) how can I add text(cidr) myself? -- 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