Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 418FB650279
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Sat,  2 Aug 2008 07:58:34 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 46854-03 for <pgsql-admin-postgresql.org@postgresql.org>;
	Sat,  2 Aug 2008 07:58:26 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.152])
	by postgresql.org (Postfix) with ESMTP id CA8D8650183
	for <pgsql-admin@postgresql.org>; Sat,  2 Aug 2008 07:58:30 -0300 (ADT)
Received: by fg-out-1718.google.com with SMTP id 16so993599fgg.23
	for <pgsql-admin@postgresql.org>; Sat, 02 Aug 2008 03:58:29 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:in-reply-to:mime-version:content-type:references;
	bh=M8SalbZdayWWiYIi2fqOoDqv81kaQygywc5mV2clykw=;
	b=VTi6lflsF/FaYxSfjEe8iCB5tzU9aSuLpBTssbIKnHgChnpG50Mjss4jq+2J2itroG
	LOP9ACBNIOJK4FnwEXPMGUbXwByksqEqOKYFjl0UM2Mp/rU92w+S4k/+KxdlJnsW0bh+
	BdPmQ6kqoZsA8V/PXGkdSWhLZERsC9KNxBvgQ=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:in-reply-to:mime-version
	:content-type:references;
	b=P1eewmn89VKRdlN4cZgoQTm6Ej1xiep/t1nUn+WRiFQIaJrzaiYQXMH63JnHhbzASG
	Js1So2KC34Drw03Q2sU1S4PaPWsljWeoeF6dpeXEO5acTppEIKpN/IHv61J/fEXhXE/c
	YH9J539+/cFPF4By0lyTl2BWwr9Zls5xcOwvY=
Received: by 10.86.96.18 with SMTP id t18mr8290076fgb.78.1217674709199;
	Sat, 02 Aug 2008 03:58:29 -0700 (PDT)
Received: by 10.86.92.18 with HTTP; Sat, 2 Aug 2008 03:58:29 -0700 (PDT)
Message-ID: <d3561eb00808020358i48a1cc1n8d69a82dccbd3953@mail.gmail.com>
Date: Sat, 2 Aug 2008 16:28:29 +0530
From: "C K" <shreeseva.it@gmail.com>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: functions
In-Reply-To: <d3561eb00808020239q6d40ab35h6e76212033f49260@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_13378_15351333.1217674709156"
References: <d3561eb00808020239q6d40ab35h6e76212033f49260@mail.gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200808/6
X-Sequence-Number: 29851

------=_Part_13378_15351333.1217674709156
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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.



-- 
Keep your Environment clean and green.

------=_Part_13378_15351333.1217674709156
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr">Dear Friends,<br><div class="gmail_quote"><div dir="ltr">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? <br>

CREATE OR REPLACE FUNCTION aa(date)<br>&nbsp; RETURNS SETOF record AS<br>$BODY$SELECT docacctransactions.accgroupid, Sum(docacctransactions.credit) AS OSC, Sum(docacctransactions.debit) AS OSD<br>FROM docs INNER JOIN docacctransactions ON docs.docid = docacctransactions.docid<br>

WHERE docs.includeinbalcalc=-1 AND docs.transactiontype&lt;&gt;1 AND docs.docdate&lt;=$1<br>GROUP BY docacctransactions.accgroupid;<br>$BODY$<br>&nbsp; LANGUAGE &#39;sql&#39; VOLATILE<br>&nbsp; COST 100<br>&nbsp; ROWS 1000;<br>ALTER FUNCTION aa(date) OWNER TO sa;<br clear="all">

<br>I am using WinXP SP 2 with PostgreSQL 8.3 with ODBC<br>Please help.<br>CPK<br>-- <br>Keep your Environment clean and green.<br>
</div>
</div><br><br clear="all"><br>-- <br>Keep your Environment clean and green.<br>
</div>

------=_Part_13378_15351333.1217674709156--