DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Received:X-Mailer:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID;
	b=F2aRU+Fe3rf8ppb9vNO0iJha361CCB3HVvu90HonoJ6ye7G38DoiEtk6M8bvP+O4m+DLVnBn/rGQUKZcFkhwMPttRYT6SPDaiV9/9ZUCEhAh1dwOYIf1Y9Kvo8E9P6Iw65MSdFuGDRCfJCAIJoWfBglWK+SgxoI732K/g5wxs/k=;
Date: Mon, 4 Aug 2008 06:33:25 -0700 (PDT)
From: Lennin Caro <lennin.caro@yahoo.com>
Reply-To: lennin.caro@yahoo.com
Subject: Re: functions
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>,
	C K <shreeseva.it@gmail.com>
In-Reply-To: <d3561eb00808020239q6d40ab35h6e76212033f49260@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Message-ID: <642766.26746.qm@web59508.mail.ac4.yahoo.com>

create a type and return this


--- On Sat, 8/2/08, C K <shreeseva.it@gmail.com> wrote:

> From: C K <shreeseva.it@gmail.com>
> Subject: [ADMIN] functions
> To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
> Date: Saturday, August 2, 2008, 9:39 AM
> Dear Friends,
> I have written a function as follows. Here I need to get
> the sum of balance
> before the user provided date. The below function works
> well, but returns
> records as a set of values, rather I need individual
> columns. What to do?
> CREATE OR REPLACE FUNCTION aa(date)
>   RETURNS SETOF record AS
> $BODY$SELECT docacctransactions.accgroupid,
> Sum(docacctransactions.credit)
> AS OSC, Sum(docacctransactions.debit) AS OSD
> FROM docs INNER JOIN docacctransactions ON docs.docid =
> docacctransactions.docid
> WHERE docs.includeinbalcalc=-1 AND
> docs.transactiontype<>1 AND
> docs.docdate<=$1
> GROUP BY docacctransactions.accgroupid;
> $BODY$
>   LANGUAGE 'sql' VOLATILE
>   COST 100
>   ROWS 1000;
> ALTER FUNCTION aa(date) OWNER TO sa;
> 
> I am using WinXP SP 2 with PostgreSQL 8.3 with ODBC
> Please help.
> CPK
> -- 
> Keep your Environment clean and green.