X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1C3CFD1B4ED; Fri, 31 Oct 2003 05:56:12 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 24837-06; Fri, 31 Oct 2003 01:55:41 -0400 (AST) Received: from joeconway.com (66-146-172-86.skyriver.net [66.146.172.86]) by svr1.postgresql.org (Postfix) with ESMTP id 76DBDD1B50E; Fri, 31 Oct 2003 01:55:39 -0400 (AST) Received: from [192.168.5.3] (account jconway HELO joeconway.com) by joeconway.com (CommuniGate Pro SMTP 4.1.5) with ESMTP-TLS id 457808; Thu, 30 Oct 2003 21:54:12 -0800 Message-ID: <3FA1F902.7000407@joeconway.com> Date: Thu, 30 Oct 2003 21:54:10 -0800 From: Joe Conway User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.3) Gecko/20030312 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Bruce Momjian Cc: Tatsuo Ishii , peter_e@gmx.net, neilc@samurai.com, chriskl@familyhealth.com.au, tgl@sss.pgh.pa.us, pgsql-hackers@postgresql.org, PostgreSQL-documentation Subject: Re: Annotated release notes References: <200310310459.h9V4x5l24309@candle.pha.pa.us> In-Reply-To: <200310310459.h9V4x5l24309@candle.pha.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/44 X-Sequence-Number: 2064 Bruce Momjian wrote: > http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-7-4 > > I need people to check this and help me with the items marked 'bjm'. I > am confused about the proper text for those sections. > Allow polymorphic SQL functions (Joe) > bjm ?? What isn't clear about this? Should/can we refer to related sections of the manual? http://developer.postgresql.org/docs/postgres/xfunc-sql.html#AEN28722 http://developer.postgresql.org/docs/postgres/extend-type-system.html#EXTEND-TYPES-POLYMORPHIC > Allow user defined aggregates to use polymorphic functions (Joe) > bjm ?? Same question. From this url: http://developer.postgresql.org/docs/postgres/xaggr.html see this paragraph: Aggregate functions may use polymorphic state transition functions or final functions, so that the same functions can be used to implement multiple aggregates. See Section 33.2.1 for an explanation of polymorphic functions. Going a step further, the aggregate function itself may be specified with a polymorphic base type and state type, allowing a single aggregate definition to serve for multiple input data types. Here is an example of a polymorphic aggregate: CREATE AGGREGATE array_accum ( sfunc = array_append, basetype = anyelement, stype = anyarray, initcond = '{}' ); Joe