From: Aaron Bono <postgresql@aranya.com>
To: Penchalaiah P. <penchalaiahp@infics.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: How to cal function in one another
Date: Wed, 2 Aug 2006 19:11:52 -0500
Message-ID: <bf05e51c0608021711m20c325c1p6ab1ec8e804d385@mail.gmail.com> (raw)
In-Reply-To: <A70AE049E81A6A40879D5DC0AC8C38C906D53194@venus.infics.com>
References: <A70AE049E81A6A40879D5DC0AC8C38C906D53194@venus.infics.com>
On 8/2/06, Penchalaiah P. <penchalaiahp@infics.com> wrote:
>
>
>
> hai,
>
> In mainfun,the query returns more than two rows,if execute query outside.
>
> I have to remove limit keyword in mainfun defination...even it returns 1st
> row values only..But i need the multful rows?
>
> so how can i do that...please help me...
>
>
>
> select subfun1(22);
>
> subfun1
>
> -------------
>
> (swarna,23)
>
>
>
> select mainfun(22);
>
> (2600,10)
>
>
>
> query result outside..
>
> select sal,dept into return_rec from emp where mgr=23 -- here i
> removed the limit keyword in mainfun definition
>
>
>
> 2600,10
>
> 3500,20
>
> 6520,10
>
>
>
> I am waiting for ur positive reply...
>
Please provide the code for your functions so we can see what you are doing.
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
==================================================================
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: postgresql@aranya.com, penchalaiahp@infics.com
Subject: Re: How to cal function in one another
In-Reply-To: <bf05e51c0608021711m20c325c1p6ab1ec8e804d385@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox