X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 980F752839 for ; Fri, 20 May 2005 07:25:37 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13184-10 for ; Fri, 20 May 2005 10:25:27 +0000 (GMT) Received: from werhmsg.werh.noaa.gov (werhmsg.werh.noaa.gov [198.206.32.236]) by svr1.postgresql.org (Postfix) with ESMTP id C0DF952827 for ; Fri, 20 May 2005 07:25:25 -0300 (ADT) Received: from [198.206.42.50] ([198.206.42.50]) by werhmsg.werh.noaa.gov (Netscape Messaging Server 4.15) with ESMTP id IGSAAW00.CDF; Fri, 20 May 2005 06:25:44 -0400 Message-ID: <428DBB25.1040206@noaa.gov> Date: Fri, 20 May 2005 06:25:41 -0400 From: "Mark Fenbers" Organization: DoC/NOAA/NWS/OHRFC User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Michael Fuhr Cc: pgsql-sql@postgresql.org Subject: Re: Aggregate Functions Template References: <428CE633.50403@noaa.gov> <20050519205611.GA92458@winnie.fuhr.org> In-Reply-To: <20050519205611.GA92458@winnie.fuhr.org> Content-Type: multipart/mixed; boundary="------------070605010306050202010906" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.066 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/165 X-Sequence-Number: 21478 This is a multi-part message in MIME format. --------------070605010306050202010906 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Yes, your varlena links are what I was looking for as a source of help... Thanks! Mark Michael Fuhr wrote: >On Thu, May 19, 2005 at 03:17:07PM -0400, Mark Fenbers wrote: > > >>I need to create an aggregate function to do some math not currently >>provided by the available tools. Can someone point to an example >>aggregate function syntax that I can use as a template for my own >>function. I'm still a little green on some aspects of PostgreSQL and am >>drawing a blank on how to do this properly from scratch. >> >> > >The General Bits newsletter has a few examples that might be helpful, >even if they're not quite what you're after: > >http://www.varlena.com/varlena/GeneralBits/109.php >http://www.varlena.com/varlena/GeneralBits/4.html > >There are sure to be some examples in the list archives -- just >search for "create aggregate": > >http://archives.postgresql.org/ > >If these links don't help, then please post more details about what >you're trying to do and what trouble you're having. If you have >any code that doesn't work the way you want but that helps show >what you're after, then go ahead and post it with an explanation >of what it does (or doesn't do) and what you'd like it to do (or >not do). > > > --------------070605010306050202010906 Content-Type: text/x-vcard; charset=utf-8; name="Mark.Fenbers.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="Mark.Fenbers.vcf" begin:vcard fn:Mark Fenbers n:Fenbers;Mark org:DoC/NOAA/NWS/OHRFC adr:;;1901 South SR 134;Wilmington;OH;45177-9708;USA email;internet:Mark.Fenbers@noaa.gov title:Sr. HAS Meteorologist tel;work:937-383-0430 x246 x-mozilla-html:TRUE url:http://weather.gov/ohrfc version:2.1 end:vcard --------------070605010306050202010906--