Re: [SQL] Output of function into a file

From: "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com>
To: karthickv(at)hclp(dot)com (karthick v), pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Output of function into a file
Date: 2002-11-12 18:48:18
Message-ID: 200211130018.18175.mallah@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql


in 7.3 you will be able to return multiple rows
with multiple columns.

7.3 stable is going to be out soon as it in beta 5 stage
currently.

regds
mallah.

On Saturday 09 November 2002 11:00, karthick v wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ian Harding 2002-11-12 18:49:28 select * from function()
Previous Message Tom Lane 2002-11-12 18:28:27 Re: how do i insert a default value?

Browse pgsql-sql by date

  From Date Subject
Next Message Paul Ogden 2002-11-12 18:52:20 Re: Inconsistent or incomplete behavior obverse in where
Previous Message Tom Lane 2002-11-12 18:44:49 Re: [HACKERS] Inconsistent or incomplete behavior obverse in where