Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP
	id 99DA3474E61; Sat,  9 Nov 2002 00:33:03 -0500 (EST)
Received: from news.hub.org (news.hub.org [64.49.215.80])
	by postgresql.org (Postfix) with ESMTP
	id 361EC474E44; Sat,  9 Nov 2002 00:33:03 -0500 (EST)
Received: by news.hub.org (Postfix, from userid 8)
	id 5123C381685; Sat,  9 Nov 2002 00:33:07 -0500 (EST)
From: karthickv@hclp.com (karthick v)
X-Newsgroups: comp.databases.postgresql.general,
 comp.databases.postgresql.sql,
	comp.databases.postgresql.novice
Subject: Output of function into a file
Date: 8 Nov 2002 21:30:06 -0800
Organization: http://groups.google.com/
Lines: 16
Message-ID: <c0ddf15d.0211082130.4dbf80ff@posting.google.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Complaints-To: groups-abuse@google.com
To: pgsql-general@postgresql.org, pgsql-sql@postgresql.org
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200211/663
X-Sequence-Number: 33084

Hi,

I am writing a small function to manipulate records in multiple
tables.  Since the function cannot return more than one value, I would
like to get all the outputs of the queries and append them into a text
file.

Is there any way to do it inside the function. I came across many
postings which tell me how to use it in pgsql but not inside the
function.

I would be very glad if someone could help me

Thanks in advance

karthick v