From: Rajesh Kumar Mallah. <mallah@trade-india.com>
To: teknokrat@yahoo.com
To: pgsql-sql@postgresql.org
Subject: Re: Can this be done with sql?
Date: Sun, 7 Jul 2002 19:06:02 +0530
Message-ID: <200207071906.02853.mallah@trade-india.com> (raw)
In-Reply-To: <1cbae208.0207041305.43dffc0@posting.google.com>
References: <1cbae208.0207031032.7d1be1a2@posting.google.com>
<1cbae208.0207041305.43dffc0@posting.google.com>
Hi,
You cannot easily return datasets from stored procedures.
there has been lots of discussion on it.
regds
mallah.
> yes, thank you, that may help but unfortunately there are are few more
> problems to face.
>
> 1. I will need to select groups from anywhere in the table so i cannot
> assume that 1 will be the start number. They will be contigous however so i
> can use another query top get the start number but is it possible to do it
> with just one select?
>
> 2. I need to display not just aggregates but the first and last value in
> the group for two of the fields. I mean by this that i need
> opening_value(field1) and closing_value(field2).
>
> 3. If this needs to be done via stored procedure how do i get it to return
> a result set. I've tried setof record but it doesn't work.
>
> thanks
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@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.
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: mallah@trade-india.com, teknokrat@yahoo.com
Subject: Re: Can this be done with sql?
In-Reply-To: <200207071906.02853.mallah@trade-india.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