Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id D10032E0153 for ; Fri, 15 Feb 2008 05:57:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 70081-02 for ; Fri, 15 Feb 2008 05:57:35 -0400 (AST) Received: from ptb-relay02.plus.net (ptb-relay02.plus.net [212.159.14.213]) by postgresql.org (Postfix) with ESMTP id 9EAA32E015D for ; Fri, 15 Feb 2008 05:10:00 -0400 (AST) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by ptb-relay02.plus.net with esmtp (Exim) id 1JPwZy-0003h7-NL; Fri, 15 Feb 2008 09:09:58 +0000 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 42F4327405A; Fri, 15 Feb 2008 09:09:58 +0000 (GMT) Message-ID: <47B556E6.8090200@archonet.com> Date: Fri, 15 Feb 2008 09:09:58 +0000 From: Richard Huxton User-Agent: Thunderbird 2.0.0.9 (X11/20071031) MIME-Version: 1.0 To: Bart Degryse CC: pgsql-sql@postgresql.org Subject: Re: Function description References: <47B56063.A3DD.0030.0@indicator.be> In-Reply-To: <47B56063.A3DD.0030.0@indicator.be> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Plusnet-Relay: 6ea7c991d365e9201dbd57de3874e19e X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/115 X-Sequence-Number: 30206 Bart Degryse wrote: > Hi all, > I find some 1553 functions in pg_catalog of which only a small part is documented in the manual. > Does anyone know where I can find what the others do with maybe an example. There's no other documentation (apart from the source) but most are repetitions and conversions: For example "\df int4" returns 8 identically named casts to cover converting from numeric, real, smallint etc. There is a similar list for int2 and most other types in the system. Likewise "\df int*mod" will show a set of modulo-calculation functions for various sizes of integer. So - they're not explicitly documented as separate functions, but they implement operators and public functions that are. -- Richard Huxton Archonet Ltd