X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 4862E4763D6 for ; Wed, 14 May 2003 14:14:21 -0400 (EDT) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with ESMTP id 18972-03 for ; Wed, 14 May 2003 14:14:19 -0400 (EDT) Received: from lerami.lerctr.org (lerami.lerctr.org [207.158.72.11]) by postgresql.org (Postfix) with ESMTP id 9951B4763D4 for ; Wed, 14 May 2003 14:14:19 -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 h4EIEGKK014421; Wed, 14 May 2003 13:14:17 -0500 (CDT) Date: Wed, 14 May 2003 13:14:16 -0500 From: Larry Rosenman To: Tom Lane Cc: pgsql-sql@postgresql.org Subject: Re: Followup from yesterday's PL/pgSQL fun... Message-ID: <283380000.1052936056@lerlaptop-red.iadfw.net> In-Reply-To: <2310.1052935992@sss.pgh.pa.us> References: <177190000.1052930499@lerlaptop-red.iadfw.net> <25250.1052931519@sss.pgh.pa.us> <25296.1052931768@sss.pgh.pa.us> <205620000.1052931835@lerlaptop-red.iadfw.net> <25363.1052932103@sss.pgh.pa.us> <271440000.1052935427@lerlaptop-red.iadfw.net> <2310.1052935992@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/298 X-Sequence-Number: 13463 --On Wednesday, May 14, 2003 14:13:12 -0400 Tom Lane wrote: > Larry Rosenman writes: >> --On Wednesday, May 14, 2003 13:08:23 -0400 Tom Lane >> wrote: >>>> I wish there was a \ command to display pg_cast... >>> >>> There is (\dC). But it's not very bright --- I don't think you can >>> limit the rows displayed at all. > >> ler=# \dC >> Did not find any relation named "C". > > Mph. It's there in CVS tip ... must have been added since 7.3. C'est la vie. That means maybe it can be smartened up to do limiting? :-) -- 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